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

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1215

---

Which joins are sql server default?

1018

---

What is the difference between function and stored procedure in sql server?

1086

---

How to use order by with union operators in ms sql server?

1028

---

Where views are stored in sql server?

996

---

Suggest a method of joining two tables.

1168

---

What is the difference between a clustered index and a non-clustered index?

994

---

Explain primary key in sql server?

1027

---

What command would you use to add a column to a table in sql server?

1318

---

What are relationships and mention different types of relationships in the dbms

967

---

How to modify an existing stored procedure in ms sql server?

1091

---

How to loop through result set objects using odbc_fetch_row()?

988

---

What is the tcp/ip port on which sql server runs?

1172

---

What is molap and its advantage? : sql server analysis services, ssas

999

---

How to create database with physical files specified in ms sql server?

1005

---