Composite Indexes (196)

最新推荐文章于 2025-01-09 08:30:00 发布

转载最新推荐文章于 2025-01-09 08:30:00 发布 · 149 阅读

本文详细介绍了复合索引的概念，解释了复合索引内的列可以任意排列，并强调了这些列在数据表中无需相邻的特点。此外，文章还指出，当SELECT语句的WHERE子句引用了复合索引的所有列或部分连续列时，查询性能将得到显著提升。同时，文中明确了复合索引的最大列数限制，对于常规复合索引为32列，而对于位图索引则为30列。

A composite index (also called a concatenated index) is an index that you create on
multiple columns in a table. Columns in a composite index can appear in any order
and need not be adjacent in the table.

Composite indexes can speed retrieval of data for SELECT statements in which the
WHERE clause references all or the leading portion of the columns in the composite
index. Therefore, the order of the columns used in the definition is important.
Generally, the most commonly accessed or most selective columns go first.

No more than 32 columns can form a regular composite index. For a bitmap index, the
maximum number columns is 30. A key value cannot exceed roughly half (minus
some overhead) the available data space in a data block.

复合索引(连接索引)
1. 合索引内的列可以任意排列,她们在数据表中也无需相邻.
2. 如果一个 SELECT 语句的 WHERE 子句中引用了复合索引的全部列或自首列开始且连续的部分列,将有助于提高此查询的性能
3. 一个常规的复合索引不能超过 32 列,而位图索引不能超过 30 列.

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-982357/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-982357/