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 |
|
influent
Constraint Violating Yak Guru
367 Posts |
 Posted - 2007-03-09 : 15:40:38
|
| If the Index Tuning Wizard has a good sample from Profiler and recommends eight indexes, all of which are already present, does it mean that one or more of the following is true?-slowness is caused by poor query design-slowness is caused by poor table design-slowness is caused by poorly chosen fill factors on the indexes-slowness is caused by fragmentationWhat else could cause slowness in relation to the suggested indexes? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-09 : 15:48:53
|
| One or more of them could be true. Here are some other possibilities:-bad execution plan-statistics outdated-hardware bottlenecks-selectivity of the first column in the index is lowTara Kizer |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-10 : 04:26:22
|
Are you queries unacceptably slow?I would check Fill Factor. Make sure it is 100% for any clustered indexes based on an incrementing key - such as Identity. (The Maint Plan changes them to 90% by default  )Also that Defragmentation and Statistics are updated often - no less than once a week.If any of those areThen I would look at Query design.Changing the Table Design will be a bigger deal - retesting of the whole application, redevelopment of queries, etc. Definitely a bigger deal! Do that last ... unless you already know that it is Pants of course ...Kristen |
|
|
|
|
|
|
index tuning - indexes already exist