Databases Reference
In-Depth Information
Figure 8.4
Example of block ID ANDing.
Figure 8.5
Example of block ID and RID ANDing.
the database to perform index ANDing and index ORing between MDC dimension
block indexes and traditional row-based (RID) indexes within the same database.
Example 2: Assume an MDC Table with Dimensions on Color and a
Traditional Non-MDC Row-based Index on PartNo
SELECT * FROM mdctable WHERE Color='Blue'
AND PartNo < 1000
Sequence:
1.
Dimension block index lookup on color.
