Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
sqldba20
Posting Yak Master
183 Posts |
Posted - 2007-08-01 : 16:00:13
|
Folks:I have a 1 Primary Clustered Index and the user created Non-Clustered Index. When I run a query and see the execution plan it uses the Primary Clustered Index (Index seek) but what could be the reason it doesn't use the Non-clustered index?Thanks ! |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-01 : 16:09:49
|
Because the optimizer thinks the clustered index will be more efficient.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|