Long Queries: Additional Techniques

Chapter 6 discussed multiple ways of improving the performance of long queries. So far, every covered technique related to rewriting queries without creating any additional database objects. This chapter addresses additional ways of improving long query performance, including different ways to materialize intermediate results. Temporary tables, CTEs (common table expressions), views, and materialized views are discussed—when each tool can improve performance and how each can be abused and lead to performance degradation. Finally, this chapter covers partitioning and parallel execution.