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 |
|
delpiero
Yak Posting Veteran
98 Posts |
 Posted - 2005-04-28 : 23:50:10
|
| What are your general opinion towards the Index Tuning Wizrard? To me, it sometimes recommends very good indexes which solve my headache for slow-running stored procedures. However, the index it recommends sometimes contain more than 8 columns in a table and I doubt whether it would cause any side effects in other aspects (e.g. inserting new records or updating these columns), though my application is not a heavily used one. Regards,delpiero |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-04-29 : 05:17:18
|
like any other tool ITW is good to a point. after that it's you experience and testing that counts.not every suggestion it makes is perfect  Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
The index tuning wizard