Question

explain creating index in table​

Answer 1

$\huge\boxed{\fcolorbox{red}{orange}{Answer}}$

SQL Server CREATE INDEX statementFirst, specify the name of the index after the CREATE NONCLUSTERED INDEX clause. Note that the NONCLUSTERED keyword is optional.Second, specify the table name on which you want to create the index and a list of columns of that table as the index key columns.

●》 An index is a copy of selected columns of data from a table, called a database key or simply key, that can be searched very efficiently that also includes a low-level disk block address or direct link to the complete row of data it was copied from.

Answer 2

(1) First, specify the name of index after the CREATE NONCLUSTERED INDEX clause. Note that the NONCLUSTERED keyword is optional.

(2)Second, specify the table name on which you want to create the index and a list of columns of that table as the index key columns.