When working with large volumes of data in a single table, the capability to divide data into distinct,
logical groups can help optimize queries.
tables has been used prior to Oracle8, and this lesson focuses on the Oracle features that enhance and expand the capability to partition tables.
By the end of the module, you will be able to:
Partition an index-organized table
Partition an object table
Partition a table with LOBs
Describe how to enable row movement in a partitioned table
Rename, move, and coalesce partitions
Exchange a partition with a table
Describe how to create a partition-wise query or join
The next lesson looks at how to partition an index-organized table.
Use the ANALYZE statement to collect statistics, for example, to:
- Collect or delete statistics about an index or index partition, table or table
partition, index-organized table, cluster, or scalar object attribute.
- Validate the structure of an index or index partition, table or table partition, index-organized table, cluster, or object reference (REF).
- Identify migrated and chained rows of a table or cluster.
: Dividing one table into several sections, or partitions, which are physically stored as if each partition were a separate table.