Indexing
Interview Questions
- What is an index and why does it improve query performance?
- What is a B-tree index?
- When should you create an index?
- What is a composite index?
- Why does column order matter in a composite index?
- What is index selectivity?
- Why might PostgreSQL not use an available index?
- What is a partial index?
- What is a covering index?
- What are the disadvantages of having too many indexes?
Next TopicReading the Plan