Monday, February 12, 2018

sql - when to use clustered index and when to use nonclustered index

Thanks for giving the time to read my question .
i have a question in my mind that
**when we should use clustered and nonclustered index**.
i have searched on the internet and found that clustered index is much
faster than the nonclustered index.
but i am confused about the usage circumstances .
can you please tell me when we should use clustered and when we should
use nonclustered index.
Looking for your kind help.



Thanks in advance .
Pooja

No comments:

Post a Comment

plot explanation - Why did Peaches' mom hang on the tree? - Movies & TV

In the middle of the movie Ice Age: Continental Drift Peaches' mom asked Peaches to go to sleep. Then, she hung on the tree. This parti...