16.20 - NUSI Bit Mapping - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Fundamentals

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
zce1519094756513.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Bit mapping is a technique used by the Optimizer to effectively link several weakly selective indexes in a way that creates a result that drastically reduces the number of base rows that must be accessed to retrieve the desired data. The process determines common rowIDs among multiple NUSI values by means of the logical intersection operation.

Bit mapping is significantly faster than the three-part process of copying, sorting, and comparing rowID lists. Additionally, the technique dramatically reduces the number of base table I/Os required to retrieve the requested rows.

Related Topics

For more information about:
  • When Teradata Database performs NUSI bit mapping, see Teradata Vantage™ - Database Design, B035-1094.
  • How NUSI bit maps are computed, see Teradata Vantage™ - Database Design, B035-1094.
  • Using the EXPLAIN modifier to determine if bit mapping is being used for your indexes, see Teradata Vantage™ - Database Design, B035-1094 or Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .