Monday, 12 February 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

casting - Why wasn't Tobey Maguire in The Amazing Spider-Man? - Movies & TV

In the Spider-Man franchise, Tobey Maguire is an outstanding performer as a Spider-Man and also reprised his role in the sequels Spider-Man...