Bitmap . Used by: Most database structures.
B-Tree. Used by: HG, LF for varchar, varbinary datatypes .
(Semi) Persistent Bit Vector. Used by: Join bloom filters and range predicate processing.
Database Consistency Checker. Used by: sp_iqcheckdb.
Fast Projection Index. Used by: Primary Column Storage.
Group Array. Used by: HG, WD index, Join Index.
Hash Tables. Used by: Queries, Enumerated FP indexes.
Long Binary. Used by: Long Binary Columns.
FP Row Fetch. Used by: Query Row projection.
FP Column Fetch.. Used by: Query Column projection.
Sort. Used by: Queries, Insert, Update, Mid Delete, DBCC.
Temporary data storage. Used by: Scrolling cursor store. Temporary query storage: union, cursors, OLAP.
