NONCLUSTERED

SQL Server

Example

CREATE NONCLUSTERED INDEX idx_employee_lastname
ON Employee(LastName);

Output

Command(s) completed successfully.

Explanation

The above SQL command creates a nonclustered index, idx_employee_lastname, on the LastName column of the Employee table. This index helps in swiftly accessing the rows in the Employee table based on the LastName field. The confirmation message “Command(s) completed successfully.” implies that the index has been created successfuly.