Re: partition

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 21 Feb 2007 16:41:03 +0100
Message-ID: <45DC680F.4010408@arcor.de>

James schrieb:
> On Feb 20, 4:43 pm, Maxim Demenko <mdeme..._at_gmail.com> wrote:
>>

Dynamic sampling was used due to not gathered statistics, but, imho, partition pruning should happen alone due to the fact that your filter is on the partition key. That is why, i asked for your original ddl for tables and view/query/explain plan - without this information one can only guess...
Do you have maxvalue defined on your partitioned tables? Are you using bind variables?
Maybe as well, you could generate and post here 10053 trace to see more details.

Best regards

Maxim Received on Wed Feb 21 2007 - 09:41:03 CST