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
No comments:
Post a Comment