Link to home
Create AccountLog 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
Create an account to see this answer
Signing up is free. No credit card required.
Create Account