Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008

    Unanswered: clustered index storage

    Hi Friends,

    I have a question regarding cluster index.If i already have a table with millions of records and then created a cluster index on that,suppose on a foreign key, how will the data be stored then.Do we need to reorg the table or its done automatically and if thats true and we do not go for reorg whether only new inserts will have indexing on it.


  2. #2
    Join Date
    May 2003
    It will not be reorged automatically.

    All rows will be in the index, regardless of whether you reorg the table. It is best if you do reorg the table (and then do runstats on table and indexes all) because DB2 does not like to use a clustered index that is not actually clustered (below about 90% clustered--I am not sure of the exact number).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts