- Mastering PostgreSQL 9.6
- Hans Jurgen Schonig
- 172字
- 2021-07-09 19:57:18
Combined indexes
In my job as a professional PostgreSQL support vendor, I am often asked about the difference between a combined and individual indexes. In this section, I will try to shed some light on this question.
The general rule is this: if a single index can answer your question, it is usually the best choice. However, you cannot index all possible combinations of fields people are filtering on. What you can do is use the properties of combined indexes to achieve as much gain as possible.
Let us suppose we have a table containing three columns: postal_code, last_name, and first_name. A telephone book would make use of a combined index like that. You will see that data is ordered by location. Within the same location, data will be sorted by last name and first name.
The following table will show which operations are possible given the three column index:

If columns are indexes separately, you will most likely end up seeing bitmap scans. Of course, a single hand-tailored index is better.
- PPT,要你好看
- Mastering Elastic Stack
- Prometheus監控實戰
- 大數據驅動的機械裝備智能運維理論及應用
- Salesforce for Beginners
- RedHat Linux用戶基礎
- Godot Engine Game Development Projects
- 軟件構件技術
- Natural Language Processing and Computational Linguistics
- DynamoDB Applied Design Patterns
- 計算機辦公應用培訓教程
- Deep Learning with PyTorch Quick Start Guide
- Outlook時間管理秘笈
- Machine Learning for Healthcare Analytics Projects
- Proteus從入門到精通100例