Re: why is the optimizer doing this?

From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Fri, 11 Feb 2011 11:30:37 -0800
Message-ID: <AANLkTimfYAe0hjOA-XmybwGmzCh=GKY=-cMvB7rm4stK_at_mail.gmail.com>



Not really addressing your question, but couldn't you just do order by b, since A is a constant?

Mike

On Fri, Feb 11, 2011 at 7:20 AM, Adams, Matthew (GE, Appl & Light) < MATT.ADAMS_at_ge.com> wrote:

> One important line got left off of the cut/paste from my previous
> efforts to post this question. The query should be
>
> select a, b, c from test1
> where a = '20110210' and b > 10 (this query will return 307 rows)
> order by a,b (this is same order as the columns in the PK)
>
>
>
> -----Original Message-----
> From: Adams, Matthew (GE, Appl & Light)
> Sent: Friday, February 11, 2011 9:00 AM
> To: oracle-l_at_freelists.org
> Subject: why is the optimizer doing this?
>
> <too long to requote>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 11 2011 - 13:30:37 CST

Original text of this message