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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2009-06-25 : 05:35:20
|
| is there a diffrence in search when i make an indexwhich is built of 3 column that i query, or if for each column i build its own index?ThanksPelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-25 : 05:37:48
|
The query will be faster if all three columns are in same index.A query can only use one index at a time. If all necessary columns are not present in the used index, a bookmark lookup or key lookup will be needed in the execution plan to get rest of the columns from the clustered index.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2009-06-25 : 05:43:13
|
| ok Thanksone more question : is the pad value of the index with value>0 Influence in any way on the search time?Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
|
|
|
same columns on diffrent indexes