InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Explain About Clusters? |
|
Answer» 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 EMP and DEPT table share the DEPTNO column. When you cluster the EMP and DEPT tables , ORACLE PHYSICALLY stores all rows for each department from both the EMP and DEPT tables in the same data blocks. 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 EMP and DEPT table share the DEPTNO column. When you cluster the EMP and DEPT tables , Oracle physically stores all rows for each department from both the EMP and DEPT tables in the same data blocks. |
|