Link to home
Start Free TrialLog in
Avatar of VIVEKANANDHAN_PERIASAMY
VIVEKANANDHAN_PERIASAMY

asked on

clusters and non clusters

i like to know for based on which queries we should use clusters and non clusters index.
Can experts give a query as an example?
Avatar of Metehan Ozcullu
Metehan Ozcullu
Flag of Türkiye image

clutered index is an index type that can exist once in a table. It is used if you have unique data on a column and does not need reorg or rebuild. on the other hand non clustered index are used for other cases and needs reorg or rebuild in time.
ASKER CERTIFIED SOLUTION
Avatar of Swadhin Ray
Swadhin Ray
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial