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?