Boost Performance with the Index Tuning Wizard

Rating:

(0)

Itzik Ben-Gan

SQL Server Magazine

InstantDoc ID #8233

Using the right indexes, your queries will run faster than ever

Have you created the optimal indexes for your database? How about the best clustered index for a table? Have you determined which indexes can improve query performance? One of the toughest issues a DBA faces is choosing the best clustered index for a primary table in the database. Choosing the best nonclustered indexes is no picnic either, requiring you to consider data distribution, the various techniques the query optimizer uses to devise an efficient plan, and how many selects vs. modifications users perform against the database so you don't create too many indexes.

Wou...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

I've found the same thing: the index tuning wizard only suggests indexes to add. I ran a trace table of update/insert activity that had bogged down due to excessive indexing. The wizard suggested that I add 2 more indexes!

Anonymous User 6/24/2005 9:47:02 AM

Yes it does appear to be a good tool, but what if you have a database which due to poor initial installation has got a clustered index on every table, and in the case of a couple of DB's I now look after, and for some tables over 10 indexes !! ITW says it will give 0% improvement so I assume it suggests that clustered indexes are always ok and it doesn't assess whether a table is over-indexed ?

Simon Letts 11/23/2000 9:20:09 AM

You must log on before posting a comment.

Are you a new visitor? Register Here