Chapter 15. Query performance tuning
This chapter covers:
Common query patterns
Spatial processing for better performance
When dealing with several tables at once—especially large ones—tuning queries becomes a major consideration. The way you write your queries is also important. Two queries can return exactly the same data, but one can take a hundred times longer to finish. The complexity of spatial objects, memory allocation, and even storage affects performance.
In this chapter, you’ll learn
- How to use the planner and read query plans
- How to write efficient queries
- How to monitor query performance
- How to organize spatial data to improve query performance
Much of this information has more to ...