What is a clustered index?

For a clustered index DB2 maintains rows in the same sequence as the columns in the index for as long as there is free space. DB2 can then process that table in that order efficiently.
  • Interview Candidate
  • 2
  • 6085

Showing Answers 1 - 2 of 2 Answers

Amol

  • Sep 2nd, 2006
 

Partitioned table is clustered by clustering index

  Was this answer useful?  Yes

burelamanohar

  • Feb 7th, 2007
 

Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions