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 |
|
kumarich1
Yak Posting Veteran
99 Posts |
 Posted - 2008-03-10 : 09:34:52
|
| I am trying to index a table. Please advise putting single index on multiple columns is good or indexing each most utilised column is good.Can anybody please send a good article on compound indices verses indexing each column.Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-03-10 : 10:04:37
|
For speed, covering indexes are best but they also are the slowest to maintain when doing INSERT, UPDATE and DELETE.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-10 : 10:24:09
|
| Checkwww.sql-server-performance.com. You will lots of article related to indexes. |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-03-10 : 10:26:42
|
quote:
- sodeep Checkwww.sql-server-performance.com. You will lots of article related to indexes.
there's quite a few here too, no?...http://www.sqlteam.com/Em |
|
|
|
|
|
|
Indices