Recommendations for Creating Indexes

Users of Microsoft SQL Server 7.0 can benefit from the new graphical SQL Server Query Analyzer and Index Tuning Wizard. These tools remove the guesswork from index creation. Nevertheless, understanding some basic index design recommendations can be useful to developers new to RDBMS.