Bitmap Indexes and Nulls (224)

tsinglee發表於2007-11-19

Bitmap indexes can include rows that have NULL values, unlike most other types of
indexes. Indexing of nulls can be useful for some types of SQL statements, such as
queries with the aggregate function COUNT.

點陣圖索引與空值
1. 與其他大多數索引不同,點陣圖索引、可以包含鍵值為NULL的行。
2. 將鍵值為空的行進行索引對有些 SQL 語句是有用處的,例如包含COUNT聚合函式的查詢。

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-982968/,如需轉載,請註明出處,否則將追究法律責任。

相關文章