Query Optimization

This section includes information about some of the new query optimization features in SQL Server 7.0. These include:

• Multi-phase optimization
• Automatic parameters
• Transitive predicates
• Nested queries
• Moving GROUP BY clauses
• Partitioned views
• Star queries
• Optimized updates