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 |
|
Kimi86
Yak Posting Veteran
79 Posts |
 Posted - 2012-07-16 : 11:09:07
|
| I am joing few tables on 3 columns - 2 of them are integers and 1 is a varchar. Should i create a composite index with these three columns on the joining tables or three individual indexes on all the joing tables |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-16 : 11:21:38
|
| Depends on the size of the tables and selectivity and how fast yoou want it to be and how many resources you can afford to use.Consider indexing the most selective column(s) and including all others.Then look at the query plan.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
question related to index