The SQL Server 6 5 Performance Optimization and Tuning Handbook

* Detailed look at factors that influence database performance

* Covers internal storage structures, indexes, and integrating SQL with Windows NT

The SQL Server 6.5 Performance Optimization and Tuning Handbook takes a detailed look at the factors that influence database performance, beginning with good physical design. The internal storage structures are covered next, because an understanding of these is essential to performance tuning. The critical subject of indexes is then discussed, followed by the query optimizer, which is perhaps the most crucial SQL Server performance topic. Making mistakes in these areas can mean the difference between a query taking seconds or literally hours.