Zero  0.1.0
SSMSTORE

Indexes and files are special cases of "stores". A store is a linked list of extents, and an extent is a contiguous group of pages. So the store is the structure that holds together an ordered set of pages that can be used by a server and have an identifier (a store ID or StoreID).

Indexes and files of records are built on stores.

Stores have logging properties and other metadata associated with them.

The property that determines the logging level of the store is sm_store_property_t.

Methods that let you get and change the metatdata are:

When a transaction deletes a file or index, the deletion of the underlying stores is delayed until the transaction commits so that the pages allocated to the stores remain reserved (lest the transaction aborts). The deleting transaction could, in theory, reuse the pages for another store, but in practice that is not done. Instead, when a store is deleted, the store is marked for deletion an put in a list for the transaction to delete upon commit. At commit time, stores that have property t_load_file or t_insert_file are converted to t_regular.