Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 145976 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 is difference between commit and rollback when used in transactions?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
System variable and temporary variables
Is truncate a dml command?
Can we add an identity column to decimal datatype?
Explain the properties of the relational tables?
How to create sub reports?
Do you know what are the differences between lost updates and uncommitted dependencies?
What is the difference between clustered index and primary key?
How to enter binary string literals in ms sql server?
What is difference between temp table and cte?
What is the rdl file?
How do you debug a procedure in sql server?
How to create nested stored procedure?
Explain syntax for dropping triggers?
