-
index clustering
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|