Advanced Indexing
Explore the tools available for query performance analysis and query optimization in PostgreSQL.
We'll cover the following...
The PostgreSQL documentation about indexes covers everything we need to know, in detail, including the following:
- Multicolumn indexes
- Indexes and ORDER BY
- Combining multiple indexes
- Unique indexes
- Indexes on expressions
- Partial indexes
- Partial unique indexes
Ask