Interested to Buy Any Domain ? << Click Here >> for more details...
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
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is load replace in db2?
What is blu acceleration in db2?
Is db2 a programming language?
Define db2.
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is dclgen in db2?
What is the maximum size of varchar data type in db2?
How do I add a column to an existing table in db2?
What are db2 tables?
What is access path in db2?
Mention the downsides of page level lock.
Which isolation level provides maximum concurrency?
How do I start db2 in windows?
