RE: Plea for Query Tuning Help
- From: "Polarski, Bernard" <Bernard.Polarski@xxxxxxxxxxxxxx>
- To: <Mark.Bobak@xxxxxxxxxxxxxxx>,<oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Sep 2006 08:32:59 +0200
I always had the impression that the SQL construction 'with <name>' is
only a cosmetic addition to SQL to avoid the inlining of views into the
main SQL text and in order to keep the logic of the SQL more evident.
Am I wrong or it has any influence on optimizer ?
B. Polarski
-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxxxxx]
Sent: Tuesday, 12 September, 2006 10:50 PM
To: charlottejanehammond@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Plea for Query Tuning Help
One more idea:
with subq as (select id from my_table where rownum=1) SELECT /*+ ordered
use_nl(nv) */ nv.* FROM subq sq, NASTY_VIEW nv where sq.id = nv.id;
Hope that helps,
-Mark
-
--
//www.freelists.org/webpage/oracle-l
Other related posts:
