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 |
|
dbwilson4
Yak Posting Veteran
50 Posts |
 Posted - 2007-06-13 : 14:17:27
|
| When I create an index in MS SQL 2005, do I create a seperate index for each column OR create ONE index and add all the columns to it? (this is in studio management)Also, when I use the database engine tuner adviser, it recomends some index additions but these are "weird" indexes. They index the primary key but with strange names like "_dta_ind48548_key" etc EVEN though the primary key is already index. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-13 : 14:26:10
|
| You shouldn't add an index to all columns and you shouldn't add one index with all columns in it. Both will slow down performance of DML operations.You can change the names that the adviser uses. We have naming conventions, so we never use the name it chooses. Also, never create an index on a column or columns if you already have it indexed. It'll be considered a duplicate and will negatively impact DML operations. Just remember that for each index that you have that SQL Server has to keep it up to date for all DML operations. Can you post the queries that you want to speed up so that we can help show you what to index?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-06-13 : 17:01:52
|
| Tara, you're great.---"Try not to become a man of success but rather try to become a man of value." |
|
|
|
|
|
|
Indexing newbie