Letting SQL Server Help with Index Selection
One of the goals of the SQL Server team was to make SQL Server an easy tool for maintaining and using databases. Index selection has always been a problem because of the knowledge required to tune a query. In addition, one must know how and when to override the query optimizer. SQL Server 2000 provides several tools to help the DBA take the guesswork out of index creation. The most effective tool is the SQL Server Index Tuning Wizard. The SQL Server Index Tuning Wizard analyzes real workloads captured by the SQL Server profiler. The SQL Server Index Tuning Wizard tests the various SQL statements found in the profiler workload and creates what if indexes. The wizard then checks the what if indexes with ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
