|
How many types of Tables supported by Oracle? Explain them.Oracle supports 4 types of tables based on how data is organized in storage:
Ordinary (heap-organized) table
- A basic, general purpose table
- Data is stored as an unordered collection (heap)
Clustered table
- A part of a cluster
- Cluster: A cluster is a group of tables that share the same data blocks as they share common columns and are often used together.
Index-organized table
- Data is stored in a B-tree index structure in a primary key sorted manner.
- Each index entry in the B-tree stores the non-key column values as well.
Partitioned table
- Data is broken down into smaller, more manageable pieces called partitions or sub-partitions.
- Each partition can be managed individually.
- Each partition can operate independently.
Advantage:
- The structure obtained from partitioning is better tuned for availability and performance.
|
