• To use the Index Tuning Wizard you can capture a workload via Profiler or use one from the Query Analyzer Query window. You specify the database, level of analysis to be done, whether you want to keep all indexes and if you want to use indexed views. Next you specify where to find the query to be analyzed (profiler trace, workload file or QA Query window). Tell it what tables to use and then let it run.

    It will provide recommendations on what index to add (or remove) and can generate the code to do so. You can either run the code right away or save it to run later.

    Check these links

    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tunesql.mspx

    http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1166357,00.html

    Toni