Re: Exceptions with Partition Pruning
"The observed performance with that use case will be inferior than having regular index on a normal table." -- That will depend on the SELECT and the index(es); please show both.
"2000 Parameters" -- What is the distribution? If your example is any indication, those parameters hit about 1/4 of the partitions. Is this typical? What are the indexes and partition key?
Subject
Views
Written By
Posted
4408
June 10, 2010 04:36PM
1985
June 12, 2010 01:21AM
2080
June 14, 2010 01:10PM
Re: Exceptions with Partition Pruning
1758
June 16, 2010 09:31AM
2140
June 16, 2010 05:28PM
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.