April 2004
Beginner to intermediate
416 pages
10h 8m
English
Content preview from Oracle Database 10g: A Beginner's Guide
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
CRITICAL SKILL 9.3
Compress Your Data
As you load more and more data into your database, performance and storage maintenance can quickly become concerns. Usually at the start of an implementation of a database, data volumes are estimated and projected a year or two ahead. However, often times these estimates turn out to be on the low side and you find yourself scrambling for more space in order to load new data. In addition to the partitioning abilities discussed in the previous section, Oracle Database 10g has the ability to compress your data and indexes to further address the concerns of performance and maintenance.
Progress Check Answers
1. The following DML commands can be applied to partitions as well as tables: delete, insert, select, ...