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.


Thanx

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).