If you want to see a big difference between CI & NCI indexes, construct a range search query.
BTW, SSN is not good for PRIMARY KEY since it has to be encrypted for security reasons.
Kalman Toth Database & OLAP Architect sqlusa.com
New Book / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012
this is just an academic example.
not a real life implementation. its only to study the effects of CI and NCI indexes.
The problem was, that by inserting data, I had always the same results.
until now, those are the results I'm getting (posted in the previous post).
No comments:
Post a Comment