Page Types

BTREEV

Variable B-Tree. Used by HG, LF for varchar, varbinary datatypes.

BTREEF

Fixed B-Tree. Used by HG, LF, WD, DT, TM, DTTM indexes for fixed datatypes. Table VDO to store index metadata.

BV

Persistent Bit Vector. Used by Join bloom filters and range predicate processing.

VDO

Variable Sized Data Object. Used by Table VDO to store index metadata.

DBEXT

DBSpace Header Block. Used by First block of each dbspace.

DBID

Database Identity. Used by One block per database.

SORT

Sort data. Used by Sort objects in the temp cache.

STORE

Temporary data storage. Used by Scrolling cursor store. Temporary query storage: union, cursors, OLAP.

GARRAY

Group Array structure. Used by HG, WD index, Join Index.

BARRAY

Byte Array. Used by FP and LOB index.

BARRAY

Blockmap. Used by Metadata for all objects.

HASH

Hash Table data. Used by Hash Objects in the temp cache.

CKPT

Checkpoint Log. Used by Checkpoint log entries in the main store.

BM

Bitmap Data. Used by Indexes, query processing and database structures.

CMID

Multiplex Commit Identity. Used by Multiplex to notify query servers of new versions.

RIDCA

Recid Cache Data. Used by Used by sp_iqcheckdb in temp only.

LOB

Long Binary Storage. Used by Long varchar and long binary storage.