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

Question

I've to apply a Non-clustered indexing to a particular tables in SQL Server for complex queries. Depending on what and in which scenarios should I go for the Non-clustered Indexing?

Shubham Kumar · Answer

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