10
Optimizing Query Performance
In this chapter, we will cover various techniques and strategies to improve the speed and efficiency of SQL queries. We will talk about query optimization and the importance of understanding query execution plans. Various key topics such as indexing, selecting appropriate data types, table partitioning, caching, normalization, and writing efficient SQL queries will be discussed. We will also cover advanced topics such as aggregations, query performance tuning techniques, monitoring, and troubleshooting slow-performing queries. This chapter will conclude by emphasizing the importance of continuous optimization to ensure that query performance remains optimized over time.
Introduction to query optimization
Query ...
Get Data Wrangling with SQL 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.
