Tables and Tables Clusters in Oracle
Автор: DBA Genesis
Загружено: 2016-04-23
Просмотров: 10854
Описание:
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
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
