Chapter 4. Reading Data Efficiently and Correctly
Originally, this chapter was called "Reading Data Efficiently." Thinking about it for a while actually convinced me that "and Correctly" should be appended to the title. The reason is that this chapter is not just about speed; it is also about getting things right and ensuring that the result can be generated fast. What good is a fast result if it happens to be just plain wrong?
The following issues will be covered:
- NULL handling
- Fixing joins
- Using cursors
- Synchronized seq scans
- Prepared queries
- Indexes and foreign keys
