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
Differentiate between cs and rr isolation levels? Where do you specify them?
Mention the location where the output received from explain statement is stored.
What is iseries database?
How to access db2 tables in mainframe?
What is netezza database?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is ibm db2 used for?
Which are the db2 tools to protect integrity of the database?
What is bind plan?
Explain in detail about buffer manager and its functionalities?
What is access path in db2?
What is phantom read in db2?
What is dpf in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How to check last update on table in db2?
