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