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

What do you mean by rollback?

0 Answers  


What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,


When do you use the IMAGECOPY?

4 Answers  


How many buffer pools are there in DB2?

2 Answers  


Explain various types of locks in db2?

0 Answers  






What are catalog tables in db2?

0 Answers  


i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,


What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,


What is the maximum No of rows per page?

0 Answers   IBM,


What is copy pending status in db2?

0 Answers  


How to access db2 tables in mainframe?

0 Answers  


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  


Categories