O'Reilly logo

Managing Time in Relational Databases by Randall Weis, Tom Johnston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required