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 |
|
madseason
Starting Member
3 Posts |
 Posted - 2008-01-03 : 07:38:41
|
| hello guys...im from chile so im not so well english writer.my question is...if i have a table with 5 index and in a query based on a select statement im not declaring any index....sql would assume by default an index??...if yes, there´s an order to do so??...THX!!! |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-01-03 : 07:49:14
|
| 1. In query, you can't declare index2. SQL Engine would determine best indexes to be used for the query based on your SELECT statement3. If you want SQL Engine to forcefully use some index, you can use hints.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
madseason
Starting Member
3 Posts |
Posted - 2008-01-03 : 07:58:38
|
| thanks a lot!! |
|
|
|
|
|
|
Indexes...