What is a clustering index ?

Answer Posted / mainframe.rahulz

A DB2 index is a clustering index if the CLUSTER keyword is
specified when the index is created.In a clustered index
rows are stored continuously in a an
order.

When you define a clustering index on a DB2 table, you
direct DB2 to insert rows into the table in the order of the
clustering key values. The first index that you define on
the table serves implicitly as the clustering index unless
you explicitly specify CLUSTER when you create or alter
another index. For example, if you first define a unique
index on |the EMPID column of the EMP table, DB2 inserts
rows into the EMP table in the order of the EMPLOYEE ID
unless you explicitly define another index to be the
clustering index

Eg:CREATE INDEX Index name
ON tablename CLUSTER;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bind plan?

805


What is role in db2?

796


Describe major components of db2?

860


Define data page.

830


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2526


What is host variable in db2 cobol?

813


What is db2 bind process?

945


What is the syntax for FETCH in DB2 ?

925


What is an instance database?

818


What is precompiler in db2?

772


What are the full forms of spufi and dclgen and why are they used?

852


What does runstats do in db2?

775


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

803


How do I start db2 in windows?

804


What is a collection in db2?

780