Hi,

I'm working on a DWH project using 9iR2.

I was wondering how "important" the clustering factor of an index is (in a DWH environment)?
During the ETL process is it worth to order the data which are inserted into a new partition over the PK columns to reduce the clustering factor of the PK Index?

Thanks for any feedback
Mike