Improved Performance Via Partitioning

Large tables (and indexes) can create or magnify several problems in production database systems because of their size and storage characteristics. For example, consider the following scenarios :

A table becomes so large that associated management operations take longer to complete than the time window which is available.

• A query requires Oracle to complete a full table scan of a very large table. Application and system performance suffers which Oracle reads the numerous data blocks for the corresponding table.

• A mission-critical application depends primarily on a single large table. The table becomes unavailable when just a single data block in the table is inaccessible due to a disk failure. An administrator must recover the entire tablespace that contains the table before the table and corresponding mission- critical application can be brought back online.

To help reduce the typesof problems that large tables and indexes can create, Oracle8 supports partitioned tables and indexes.

Domain Name Search