Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What is the purpose of a cluster?
What is the purpose of a cluster?
✍: Guest
A cluster provides an optional method of storing table data. A cluster is comprised of a group of tables that share the same data blocks, which are grouped together 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, Oracle physically stores all rows for each department from both the EMP and DEPT tables in the same data blocks. You should not use clusters for tables that are frequently accessed individually.
2011-11-22, 2787👍, 0💬
Popular Posts:
How To Retrieve Input Values for Checkboxes Properly? - PHP Script Tips - Processing Web Forms If mu...
How to reduce the final size of an executable file? Size of the final execuatable can be reduced usi...
What’ is the sequence in which ASP.NET events are processed ? Following is the sequence in which the...
.NET INTERVIEW QUESTIONS - What is the difference between thread and process? A thread is a path of ...
How To Truncate an Array? - PHP Script Tips - PHP Built-in Functions for Arrays If you want to remov...