Re: Dynamic Partition Pruning
Hi Sergey,
thanks you very much for the explanation. I was trying it without any index and this feature only works when using an index on the fact table.
I tried that with a lookup (dim_times) of 5,000 records and a fact of 1,000,000 records (fact_items) range partitioned by year (partitions) and it turned out to be slightly faster on the partitioned table (1.17 seconds vs. 1.06 seconds). What kind of test would you suggest to see a more obvious case here? Could it say: The smaller the partitions (and therefore the less levels the BTree Index has) the more obvious are the differences?
Regards
Peter
Subject
Views
Written By
Posted
5596
September 21, 2006 04:27AM
3424
September 21, 2006 03:27PM
2722
December 09, 2006 08:25AM
4062
December 10, 2006 11:52PM
Re: Dynamic Partition Pruning
4005
December 15, 2006 07:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.