How many clustering indexes can be defined for a table?

Answers were Sorted based on User's Feedback



How many clustering indexes can be defined for a table?..

Answer / s

Only one clustering index can be defined.

Is This Answer Correct ?    11 Yes 0 No

How many clustering indexes can be defined for a table?..

Answer / mehdee

Yes Only one clustering index can be defined.And reason is
Clustered indexe is created to order the rows in the
DB2 table in the same physical order as the desired result
from the indexe. And if we do not use this option, DB2 will
come up with one to do this ordering rows.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB2 Interview Questions

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  


what is REORG? what is the use?

4 Answers  


What does db2 mean?

0 Answers  


how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,


What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,






when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was

5 Answers   IBM,


Do we need cursor for Count(*)?

4 Answers   iGate,


How do I import a csv file into db2?

0 Answers  


How does DB2 store NULL physically?

2 Answers  


what are bind concepts in db2 cobol?

0 Answers  


assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,


Where are plans stored?

2 Answers  


Categories