9. LOOKUP Table Usage
9. LOOKUP Table Usage
LOOKUP tables load persistently stored reference and master data into memory at server startup, providing fast access by PRIMARY KEY. This chapter covers the memory-resident architecture, JSON and SEQUENCE, JOIN, and DML with general predicates.
Chapter Contents
| Section | Topics |
|---|---|
| Overview and Use Criteria | Purpose and selection criteria |
| Table Structure and Schema | Columns, primary keys, and schema design |
| Create, Alter, and Drop | CREATE, ALTER, and DROP DDL |
| Data Ingestion and Modification | INSERT, Append, reload, and deletion |
| Queries and Analysis | SELECT, JOIN, and predicate queries |
| Indexes and Performance | Red-black indexes, secondary indexes, and tuning |
| Operations and Data Lifecycle | Backup, recovery, and persistence |
| Constraints, Errors, and Troubleshooting | Limitations, error causes, and remedies |
| Usage Patterns and Scenarios | Code tables, reference data, and thresholds |
| PRIMARY KEY Policy | Natural versus surrogate keys and key immutability |
| SEQUENCE Columns | Automatic numbering and NEXTVAL |
| JSON Columns and Queries | Supported JSON features, path predicates, and primary key restrictions |
| UPDATE/DELETE with General Predicates | Modifications using non-PK, range, string, date, and JSON path predicates |
Last updated on