Post reply

index tuning wizard

  • April 13, 2007 at 6:43 am

    #171983

    hi guys,

    i'm still learning the ropes on sql server 2000, so bear with me...

     

    i'm busy writing a query on a table with 7 million records that joins to itself. this table had no indexes before i started writing the query, since it is a audit table and is not really used except for back-end querying every blue moon.

     

    i find myself using the index tuning wizard alot, and i was wondering if there is a way to call the itw and pass in the file name, table names, table rows etc. with transact sql?

  • April 17, 2007 at 3:33 pm

    #701035

    Your using index tuning wizard on SQL2000.  All I can say is your brave!

    Personally I wouldn't touch it...As your new to SQL Server, I would seriously recommend reading up on indexes before allowing ITW to create any indexes.  Get a feel for what it is trying to do.

    As for the passing the information in via t-sql.  Never tried it personally, but I suppose you could do it with some dynamic sql code.  But this would mean using xp_cmdshell which I don't like using.  I'd remove this from our system if the dev team hadn't used it already

Viewing 2 posts - 1 through 1 (of 1 total)

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