What is a clustering index ?

Answers were Sorted based on User's Feedback



What is a clustering index ?..

Answer / s

Clustering index determines where the row will be inserted.

Is This Answer Correct ?    1 Yes 0 No

What is a clustering index ?..

Answer / saeed

clustering index attempts to maintain a particular order of
data, it try to keep newly inserted rows clustered
according to an index and avoid page splits.

Is This Answer Correct ?    1 Yes 0 No

What is a clustering index ?..

Answer / 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

More DB2 Interview Questions

Mention and explain the contention situations caused by locks?

1 Answers  


What is dclgen in db2?

0 Answers  


how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,


Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,


What is consistency token in db2?

0 Answers  


What is db2 purescale?

0 Answers  


what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,


How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,


what is the soft code for deadlock ?

2 Answers   Logica CMG,


Explain the contents that are a part of dclgen.

0 Answers  


What are iseries servers?

0 Answers  


What is a page in db2?

0 Answers  


Categories