MSDN: Index Tuning Wizard for Microsoft SQL Server 2000
        
        By Bill Graziano
            on 4 October 2000 
        | Tags: 
            
            
                
                Performance Tuning
            
                ,
                Indexes
            
        
            
        
            
        This article describes the Index Tuning Wizard in Microsoft SQL Server 2000. The Index Tuning Wizard simplifies the task of identifying which indexes to create in a table and also optionally generates scripts to create them by analyzing a user-supplied workload.