0
Good afternoon, you guys!
I was researching about Primary Key Clustered and found that answer:
"The difference that actually exists is between the fields of the type NONCLUSTERED clustered clusters. CLUSTERED-type indexes define order where data is physically stored in a table, that within of the table, being unique, already the NONCLUSTERED indexes is stored in a location and table data are stored elsewhere. Thus, the CLUSTERED indexes gain in performance by being in the table."
But I would like to know, in which case is it better to use NONCLUSTERED? Has some gain?
Thank you!!
Whenever it is necessary to create another index for your table as there can only be one clustered index, the others will necessarily have to be unsclustered. About gain you have to analyze whether the existence of a secondary index will be useful for your application.
– anonimo