Bitmap Indexes and Nulls (224)
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聚合函式的查詢。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-982968/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Indexes and Nulls (198)IndexNull
- The Secrets of Oracle Bitmap IndexesOracleIndex
- Restrictions on Create Bitmap IndexesRESTIndex
- Bitmap Indexes (220)Index
- bitmap indexes 的結構分析Index
- Bitmap Indexes on Partitioned Tables (225)Index
- Bitmap Join Indexes (226)Index
- Bitmap Indexes on Index-Organized Tables (232)IndexZed
- 有關Bitmap Join Indexes的精彩帖一Index
- 有關Bitmap Join Indexes的精彩帖二Index
- 高效的SQL(bitmap indexes optimize low cardinality columns)SQLIndex
- Bitmap Indexes 學習與測試_20091213Index
- json_strip_nullsJSONNull
- 分析函式——NULLS FIRST/LAST函式NullAST
- Nulls Indicate Absence of Value (162)Null
- Rebuild IndexesRebuildIndex
- ORACLE INDEXESOracleIndex
- Oracle - Tables/IndexesOracleIndex
- Reverse Key IndexesIndex
- ORACLE -> NULL & INDEXESOracleNullIndex
- Overview of Partitioned IndexesViewIndex
- Local Partitioned IndexesIndex
- Global Nonpartitioned IndexesIndex
- Extents in Indexes (19)Index
- bitmap
- 翻譯(九)——Clustered Indexes: Stairway to SQL Server Indexes Level 3IndexAISQLServer
- BITMAP索引的INLIST ITERATOR與BITMAP OR索引
- c# svg轉Bitmap Bitmap轉ImageSourceC#SVG
- [20140621]Cluster Nulls.txtNull
- skip_unusable_indexesIndex
- Global Range Partitioned IndexesIndex
- Global Hash Partitioned IndexesIndex
- Maintenance of Global Partitioned IndexesAINaNIndex
- Overview of Indexes (194)ViewIndex
- Jedis bitmap
- Bitmap IndexIndex
- Sparse Indexes vs unique indexIndex
- SKIP_UNUSABLE_INDEXES InitializationIndex