How a Non-clustered indexing is best and in which scenario?

just follow this link

https://www.mssqltips.com/sqlservertip/3041/when-sql-server-nonclustered-indexes-are-faster-than-clustered-indexes/

A clustered index specifies the physical storage order of the table data (this is why there can only be one clustered index per table).If there is no clustered index, inserts will typically be faster since the data doesn't have to be stored in a specific order but can just be appended at the end of the table.On the other hand, index searches on the key column will typically be slower, since the searches cannot use the advantages of the clustered index.

so if u have dml operation frequently on table so use non-clustered but if hv ddl operation use clustered

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Shubham Kumar10y ago
just follow this link

https://www.mssqltips.com/sqlservertip/3041/when-sql-server-nonclustered-indexes-are-faster-than-clustered-indexes/

A clustered index specifies the physical storage order of the table data (this is why there can only be one clustered index per table).If there is no clustered index, inserts will typically be faster since the data doesn't have to be stored in a specific order but can just be appended at the end of the table.On the other hand, index searches on the key column will typically be slower, since the searches cannot use the advantages of the clustered index.
so if u have dml operation frequently on table so use non-clustered but if hv ddl operation use clustered

0