- 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.
- 流處理器研究與設計
- 80x86/Pentium微型計算機原理及應用
- Pig Design Patterns
- 網(wǎng)絡化分布式系統(tǒng)預測控制
- 走近大數(shù)據(jù)
- R Data Analysis Projects
- C++程序設計基礎(上)
- SQL Server數(shù)據(jù)庫應用基礎(第2版)
- 單片機技術項目化原理與實訓
- 筆記本電腦電路分析與故障診斷
- Microsoft Dynamics CRM 2013 Marketing Automation
- Moodle 2.0 Course Conversion(Second Edition)
- PostgreSQL 10 High Performance
- 軟件質量管理實踐
- 微計算機原理及應用