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 |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2008-06-16 : 05:32:55
|
| Hi ,Iam just checking whether which index is called while executing the below query:set showplan_text onSelect * from tester where age>25Table Structure[Tester]:Sno int,name varchar(25),age intClustered index on sno [index name:cid_test ]non clustered index on age [index name:ind_te_age]index called is cid_testMy doubt is actually is should call ind_te_age |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-16 : 14:19:20
|
| Dups: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104886 |
 |
|
|
|
|
|
Index Execution