Long Queries and Full Scans
摘要
Chapter 5 discussed short queries and explained how to identify short queries and optimization strategies and techniques applicable to them. It also covered the importance of indexes for short queries, the most commonly used index types, and their applications. Chapter 5 also provided an opportunity to practice reading execution plans and, hopefully, acquire confidence in the PostgreSQL optimizer.