Course ID: CS540_CStudent ID: 14072Student Name: Lavanya SomaHomework : 061)Table partition: Scalability and availability are major concerns when there is a table in a database with high concurrent usage. In such cases, data within a table may be stored in several partitions, each of which resides in a different tablespace. The Oracle server currently supports partitioning by a range of key values or by a hashing algorithm. If a table is partitioned, each portion is a segment, and storage parameters can be specified to control them independently. Use of this type of segment requires the partitioning option within the Oracle9i Enterprise Edition.2) Cluster:A cluster, like a table, is a type of data segment. Rows in a cluster arestored based on key column values. A cluster may contain one or moretables. Tables in a cluster belong to the same segment and share thesame storage characteristics. The rows in a clustered table can be
accessed with an index or hashing algorithm.3)Index-Organized Table:In an index organized table, data is stored within the index based on the key value. An index organized table does not need a table
You've reached the end of your free preview.
Want to read all 4 pages?
- Spring '16
- Oracle Database, Oracle Corporation, Disk partitioning