- Sybase® SQL Server Performance and Tuning Guide
Chapter 9
Advanced Optimizing Techniques
- What Are Advanced Optimizing Techniques?
- Specifying Optimizer Choices
- Specifying Table Order in Joins
- Increasing the Number of Tables Considered by the
Optimizer
- Specifying an Index for a Query
- Specifying I/O Size in a Query
- Specifying the Cache Strategy
- Controlling Prefetching and Cache Strategies for
Database Objects
- dbcc traceon 302