Estimate the size of your unique secondary indexes using the following equations.
Because the index is unique, there is one USI subtable row for each row in the base table, so the row counts are identical.
USI Sizing Equation
The following parameter definitions are used with this equation:
| Parameter | Definition |
|---|---|
| Index Value Size | Size of the column set on which the USI is defined. This must include any trailing pad bytes added for alignment purposes. All row lengths must be an even number of bytes (see Base Table Row Format), so be sure to take this into account. |
| Block Overhead | Sum of the following factors.
|
Packed64 Format Sizing Equations
NPPI USI subtable size = ((Row Count) × (Index Value Size + 28))
PPI USI subtable size = ((Row Count) × (Index Value Size + 30))
Aligned Row Format Sizing Equations
NPPI USI subtable size = ((Row Count) × (Index Value Size + 28))
PPI USI subtable size = ((Row Count) × (Index Value Size + 30))
If fallback is defined for the base table, then double the calculated result.
Vantage creates a unique secondary index on any column set specified as PRIMARY KEY or UNIQUE, so take these indexes into consideration for your capacity planning. PRIMARY KEY and UNIQUE constraints are typically implemented as single-table join indexes for temporal tables. You must also take any of these system-defined join indexes into account when doing capacity planning.