- 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.
- Mastering Spark for Data Science
- Java實用組件集
- R Machine Learning By Example
- 極簡AI入門:一本書讀懂人工智能思維與應用
- Cloud Analytics with Microsoft Azure
- 數控銑削(加工中心)編程與加工
- Windows XP中文版應用基礎
- AWS Certified SysOps Administrator:Associate Guide
- 樂高機器人—槍械武器庫
- 人工智能實踐錄
- 網絡服務搭建、配置與管理大全(Linux版)
- Building a BeagleBone Black Super Cluster
- Machine Learning Algorithms(Second Edition)
- 步步驚“芯”
- 計算機硬件技術基礎學習指導與練習