Overview of Clusters (238)
Clusters are an optional method of storing table data. A cluster is a group of tables
that share the same data blocks because they share common columns and are often
used together. For example, the employees and departments table share the
department_id column. When you cluster the employees and departments
tables, Oracle physically stores all rows for each department from both the
employees and departments tables in the same data blocks.
Because clusters store related rows of different tables together in the same data blocks,
properly used clusters offers these benefits:
■ Disk I/O is reduced for joins of clustered tables.
■ Access time improves for joins of clustered tables.
■ In a cluster, a cluster key value is the value of the cluster key columns for a
particular row. Each cluster key value is stored only once each in the cluster and
the cluster index, no matter how many rows of different tables contain the value.
Therefore, less storage is required to store related table and index data in a cluster
than is necessary in nonclustered table format. For example, in Figure 5–10, notice
how each cluster key (each department_id) is stored just once for many rows
that contain the same value in both the employees and departments tables.
簇
1. 簇由一組擁有相同的列且經常被一起使用的資料表構成,這組表在儲存時可共享資料塊
2. 簇有以下的優點
a. 連線簇表所需的磁碟 I/O 會減少
b. 連線簇表所需的時間將減少
c. 在一個簇中,簇鍵值是指簇鍵列distinct的值。一個簇內的由多個簇表的各個資料行所使用的相同的簇鍵值,
在簇及簇索引中只會被儲存一次。因此所需的儲存空間更少。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-983126/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Overview of Hash Clusters (239)View
- leetcode 238LeetCode
- 238_移動零
- Oracle 21C Flex ClustersOracleFlex
- Oracle 21C Extended ClustersOracle
- Listing Chained Rows of Tables and ClustersAI
- Oracle Real Application Clusters GFSOracleAPP
- Flutter OverviewFlutterView
- [ABC238E] Range Sums
- dart class overviewDartView
- Stormstarter-OverviewORMView
- Overview of PartitioningView
- Overview of Database CheckpointsViewDatabase
- Overview of Unix ResourcesView
- oracle function overviewOracleFunctionView
- Item Import OverviewImportView
- Overview of Extents(11)View
- Overview of Partitioned IndexesViewIndex
- Overview of Tablespaces (38)View
- Overview of Views (174)View
- Overview of Datafiles (62)View
- Overview of Segments (22)View
- 高通USB overviewView
- Validating Tables, Indexes, Clusters, and Materialized ViewsIndexZedView
- RH436 UNIT 1 CLUSTERS AND STORAGE薦
- How a Database Is Mounted with Real Application Clusters (294)DatabaseAPP
- CRS and 10g Real Application ClustersAPP
- Overview of Availability in a CDBViewAI
- 2.4 Overview of Services in a CDBView
- 7-Overview-namesView
- 8-Overview-NamespacesViewnamespace
- 10-Overview-AnnotationsView
- [英] TensorFlow OverviewView
- Deadlock Overview and DiscussionView
- Overview of Data Blocks(二)ViewBloC
- Overview of Tables (154)View
- Overview of Dimensions (191)View
- Overview of Synonyms (193)View