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
How to connect to db2 database from windows command line?
What is release/acquire in bind?
How do we specify index to include or not during bind process.
How can we retrieve the total number of records in RPG & CLLE?
Explain about rct in db2?
what is utility for parm lib
What is runstats utility in db2?
What is db2 look?
What is consistency token in db2?
What is the difference between bind and rebind in db2?
What is iseries database?
What is the use of commit in db2?
What is the picture clause of null indicator variable?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is blu acceleration in db2?