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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-05-23 : 14:48:16
|
| Let's say you have an index on field2 in table1.You would like to run a select query which does not use field2 as index. IS there a way to do this in sql.p.s. This was a question that someone asked me?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-23 : 14:49:27
|
| You can use an index hint to force a different index to be used. If you don't use an index hint though, you'll get whatever the query optimizer thinks is most efficient in your execution plan.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
|
|
|
index