Wrapping Query in "select *" changes execution path

From: Ray Feighery <rjfeighery@xxxxxxxxx>
To: Oracle-L List <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 4 Jun 2010 10:24:57 +1000

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-l

Follow-Ups:

Re: Wrapping Query in "select *" changes execution path
From: Ray Feighery

Re: Wrapping Query in "select *" changes execution path
From: William Robertson

Wrapping Query in "select *" changes execution path

Other related posts: