15. Optimizing Asserted Versioning Databases
Bi-Temporal, Conventional, and Non-Temporal Databases350
Data Volumes in Bi-Temporal and in Conventional Databases350
Response Times in Bi-Temporal and in Conventional Databases351
The Optimization Drill: Modify, Monitor, Repeat351
Performance Tuning Bi-Temporal Tables Using Indexes352
General Considerations353
Indexes to Optimize Queries354
Indexes to Optimize Temporal Referential Integrity366
Other Techniques for Performance Tuning Bi-Temporal Tables372
Avoiding MAX(dt) Predicates372
NULL vs. 12/31/9999372
Partitioning373
Clustering375
Materialized Query Tables376
Standard Tuning Techniques377
Glossary References378
One concern about Asserted Versioning is with how well it will perform. We believe that ...

Get Managing Time in Relational Databases now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial