Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 148200 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
Do you know how to store and query spatial data?
What is triggers in ms sql server?
What does the update command do?
What is explicit mode in sql server?
What is filter index?
What is difference between views and tables?
What is a result set object returned by odbc_exec()?
Explain try...catch with sql server?
Explain what role entity and relationship play in an ER diagram.
How to use union to merge outputs from two queries together in ms sql server?
What is the Control Flow in SSIS
What is the contrast amongst drop and truncate?
Why are sql functions used?
What are ddl (data definition language) statements for tables in ms sql server?
What is a field in a table?
