Making Older Data Read-Only
Especially within the data warehouse environment, it is important to be able to make older data read-only because it speeds up query time. It can also assist in reducing the backup times on very large databases (VLDBs), as data and indexes that reside in read-only tablespaces only have to be backed up occasionally.
If you are using date- or timestamp-based partitioning on your tables and indexes, it is important to segregate both the data and index partitions into tablespaces based on that date-based interval. Once data becomes static and no longer updated, you can then make those tablespaces read-only. So, during physical database design, the DBA needs to consider whether making data read-only is a necessity for the ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database 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.
