How many clustering indexes can be defined for a table?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I add a column to an existing table in db2?

814


How to view db2 table structure?

822


What is buffer pool?

874


What is db2 connect?

838


What is the use of predicate?

818


What is dclgen (declaration generator)?

839


How to access db2 tables in mainframe?

839


How would you find out the total number of rows in a db2 table?

810


How to compare data between two tables in db2?

871


How to resolve deadlock issue

19106


What is reorg?

875


What is a system catalog table in db2?

872


Explain about rct in db2?

886


What is the use of reorg in db2?

851


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2701