Table IndexSpecialWIDTable
Special WIDs are low-valued WIDs, assigned to globally and frequently used
WIDs within a dataset, such as its DataSetWID. They are both more
mnemonic, and potentially more efficient to store. Warehouse.MaxSpecialWID
delimits special and regular WIDs.
Analogous to WIDTable, this table is used to allocate special WIDs.
MySQL dataset loaders use the following protocol for WID assignment:
DELETE FROM SpecialWIDTable;
INSERT INTO SpecialWIDTable VALUES ();
SELECT last_insert_id();
This table contains exactly one row at any given time.
Columns
Column |
MySQL Type |
Oracle Type |
Nullable |
Description |
PreviousWID |
BIGINT |
NUMBER |
No |
Last-used special WID
|
Referenced By
None.
Other Constraints
None.
Indexes
None.