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 - 2007-11-27 : 16:47:06
|
| How Multiple Columns Index works?I have a bunch of tables , in report scripts sometimes I use single column in where clause or combination of one or two columns in where clause, so my question is do I have to create multiple column indexes or index each column individually. If I create multiple columns index and if I don't use all the indexed columns in the where clause or in Joins how does it affect the performance of the report or best thing is indexing each column.Please advise |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-27 : 16:49:09
|
| Post your most common queries and we'll tell you what indexes to create. Let us know if the tables involved in the queries have primary keys setup and if they are clustered or non-clustered.And no it is not best to create an index on each column. You will receive a performance penalty on DML operations due to this.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Multiple Columns Index