Significance of cluster table or non cluster table - oracle

Explain the significance of cluster table or non cluster table.

A Cluster provides an alternate method of storing table data. It is made up of a group of tables that share the same data i.e. same columns and thus are often used together. Primary benefits of this approach are:
- Disk I/O is reduced and access time improves for joins related to clustered tables.
- Cluster key is the common column/s among the table which reduces storage needs.

Non cluster tables must be used if individual tables are used/accessed frequently.
What is pragma restrict_reference in oracle 9i?
Pragma restrict_reference - Pragma restrict_reference is used to check for violations of any rules applied, at compile time. It’s used in functions to obey some...
Why can't we assign not null constraint as table level constraint?
Not null constraint - Not NULL is a column level constraint to ensure that any value in that column is not null...
Use of between page triggers in REPORTS - oracle
The between-page trigger is used for creating conditional formatting, eg: retrieving information...
Post your comment