asked
Index usage in query plan
If PK is on ID and non-clustered index (IX_1) is on First, Last, and Age, and Would query "Select Age from Users where ID = 24" use IX_1 or would it go PK and do row scan on PK
My initial guess, assuming your primary key is also your clustering key, is that it would do a clustered index seek since that's the primary key it should do a seek to locate the record. The Age is already included in the clustered index since that's essentially the table anyway. If the table is small, it's possible that it would do a clustered index scan so that's a potential. Why not try it and see what it does?
18 People are following this question.
