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

My sql statement select avg(salary) from emp yields inaccurate results. Why?

880


Mention the various locks that are available in db2.

812


How to create backup table in db2?

873


Mention the location where the output received from explain statement is stored.

888


How to find the number of rows in a db2 table?

880


What is page size in db2?

765


Can there be more than one cursor open for any program?

930


Discuss about db2 bind?

893


Explain about rct in db2?

886


How can we read records for specific member in CL? AND rpg?

484


What does runstats do in db2?

795


i want to maintain uniqueness on pdf without make lf??????????

1926


What is db2 connect?

833


What is meant by explain?

878


What is a db2 package?

819