Re: Missing optimization when dealing with parittioned range partitions + MIN()/MAX() queries ?

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Tue, 08 Feb 2011 18:12:39 +0100
Message-ID: <4D517987.4040904_at_gmail.com>



This particular query is not equivalent for at least some reasons. 1) There is no quarantee, that data is available in the first partition at all (you can't consider fresh statistics as replacement for that) 2) You can get data in wrong partitions (for example by executing exchange partition without validation)

Best regards

Maxim

On 08.02.2011 17:53, Nilo Segura wrote:
> This particular query is equivalent to
>
> explain plan for select min(z) from table2000 partition (tab_1999_h1);
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 08 2011 - 11:12:39 CST

Original text of this message