Tables and Tables Clusters in Oracle

Clustering is a method of storing tables that are intimately related and often joined together into the same area on disk. The #cluster key is the column or columns by which the tables are usually joined in a #query.
By storing the field comprising the Cluster Key once instead of multiple times, storage is saved. The arguably more significant advantage to Clustering is to expidite join queries. When a query is fired that joins these 2 tables by Cluster Key, the joined rows would be fetched with a single IO operation.
A cluster is a #data structure that improves retrieval performance.

0:00 Intro
1:13 Difference between Database User & Database Scheme
8:42 Schema Objects
16:17 Tables in Database
26:31 What is a Table Cluster?
40:54 Creating Cluster Table
56:36 How Cluster table look like

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis