Glossary

Table: HTXN_HISTORY (transaction log)

`LOCKSIZE PAGE` — Insert-heavy, row locking overhead not justified - `LOCKMAX 5000` - Partitioned by date (monthly) - Online inserts into current partition only - Batch reads from previous partitions (no contention with online inserts) - Online reads use UR (historical queries don't need current acc

Learn More

Related Terms