Difference between Cluster and Non-cluster index?
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
How can we delete a table in sql server?
Difference between LEN() and DATALENGTH() in sql server ?
what exactly sql injuction.how to overcome.....
What happens when unicode strings concatenate with non-unicode strings?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What is log cache in sql server?
What are “lost updates”?
What is the fastest way to permanently delete a 1 million row table named customers?
What is trigger in salesforce?
What is cross join in sql server joins?
How to create function with parameter in sql server?
What is self contained scalar sub query?
How to use column default values in insert statements in ms sql server?
What is the difference between mysql and sql server?
What are clustered and non-clustered index?