Wrapping Query in "select *" changes execution path
From: Ray Feighery <rjfeighery_at_gmail.com>
Date: Fri, 4 Jun 2010 10:24:57 +1000
Message-ID: <AANLkTims1P2RuoW2amlV_vPwC9VoLxuKRFJffL9pdRUr_at_mail.gmail.com>
All
Date: Fri, 4 Jun 2010 10:24:57 +1000
Message-ID: <AANLkTims1P2RuoW2amlV_vPwC9VoLxuKRFJffL9pdRUr_at_mail.gmail.com>
All
Oracle 10.2.0.4
Red Hat 4 x86_64
We have an application that runs standard SQL as a reporting tool. The amount of rows that can be returned is limited by a variable. The application manages this by changing the straight SQL from this:
select *
from users;
into this:
select * from (
select * from users)
where rownum < 25000
This is causing a change in some execution paths.
Is there any (simple) way I can stop or influence this behaviour?
Thanks
Ray
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 03 2010 - 19:24:57 CDT