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

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,


what is cursor stability?

2 Answers   IBM,


wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,


What is the picture clause of the null indicator variable?

6 Answers  


what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,


how can u nderstand the sql stmts executed successfully or not ?

1 Answers   TCS,


What is cursor stability?

1 Answers  


query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,


insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,


What is the purpose of using commit?

0 Answers  


What is QUIESCE?

2 Answers  


What is the role of data manager in the db2 database?

0 Answers  


Categories