Post reply

Do you like the Index Tuning Wizard?

  • April 7, 2004 at 4:30 pm

    #76146

    Hi there,

    I've got a 65- table SQL Server 2000 database, and I'm considering using the Index Tuning Wizard to build new indexes. Have you used it? Do you like it? How did it work for you? I'm trying to figure out if it's a good way for me to build indexes.

    Thanks for your comments,

    Nadya

  • April 8, 2004 at 12:22 am

    #502078

    I like the wizard! It is a good starting point. It builds the foundation you can go further on. Once you've built your indices, it's up to you to monitor query performance.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • April 8, 2004 at 6:47 am

    #502130

    I think the tuning wizard works fine.  I like it for analyzing a work load.

    I usually don't use it since my tuning efforts are usually focused on one SP at a time so I simply view the execution plan and determine where a new index is needed or modifying an existing one will help.

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • April 8, 2004 at 8:18 am

    #502156

    When your queries are not very complex and don't involve joins to tables in different databases, the tuning wizard works great. I have used it hundreds of time and it almost always comes up with 1 suggestion that I hadn't thought of that increases my performance. However I often have queries that span multiple databases and even servers, and it is not very helpful.

  • April 9, 2004 at 5:56 am

    #502271

     I have used it a few times and seems to work fine.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply