Hi,
I am studying for MCTS and through some of the course material it recommends that a low selectivity field i.e. First Name is a good canditate for a clustered index.
This goes against what is recommended online (completely the opposite) and goes against what I have been taught in the past.
What is correct for the exam?
Thanks
I often find various printed 'study' media with errors. Mark this one as just that.
Indexes, both clustered and non-clustered, may lose their effectiveness when selectivity becomes too low. The Query Processor may ignore a low selectivity index.
No comments:
Post a Comment