Difference between Cluster and Non-cluster index?
- 32 Answers
- 140177 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / hannan
First, you must understand what a cluster is in Oracle.
A cluster is simply a method for storing more then 1 table
on the same block. Normally
-- a block contains data for exactly 1 table. In a cluster
-- you have data from many
tables sharing the same block.
For example -- if you join the data from EMP and DEPT by
DEPTNO frequently -- you might
consider clustering this data by DEPTNO. In that fashion
all of the rows from EMP for
deptno=10 and the row in DEPT for deptno=10 will reside on
the same exact block (one IO
to get all of the data instead of some IO's to EMP and DEPT).
In order to organize data in such an object, we create a
cluster KEY -- deptno in our
above example. We must index this cluster key. This index
on deptno in the cluster is
called a CLUSTER INDEX and is used to locate the blocks that
contain data about deptno=10
| Is This Answer Correct ? | 21 Yes | 4 No |
Post New Answer View All Answers
What are secondary xml indexes?
What is explicit mode in sql server?
Where the sql logs gets stored? : sql server database administration
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Describe triggers features and limitations?
What is explicit cursors?
What is query and its types?
What is constraints and its types?
How you can get the list of largest tables in a database?
What is the purpose of update statistics and scope_identity() function?
How to convert a numeric expression from one data type to another?
How can i Relate Tables in SSIS
What types of replication are supported in sql server?
What is a database table?
