RE: why is the optimizer doing this?

From: Adams, Matthew (GE, Appl & Light) <"Adams,>
Date: Fri, 11 Feb 2011 10:20:37 -0500
Message-ID: <81BA3F0709F0B343AF28678897F2F3A301396EA0_at_LOUMLVEM03.e2k.ad.ge.com>



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
Received on Fri Feb 11 2011 - 09:20:37 CST

Original text of this message