Re: Stored Outline Not Used

Steve Howard wrote:
> Shamallow wrote:
> > Instead of using outlines to achieve your goal, you should use
> > DBMS_ADVANCED_REWRITE package (on 10gR2) to add an "hidden" order by
> > clause to the faulty query
> >
> This was really interesting, as I have not used this. I could not get
> it to work with the ORDER BY, even with different validate and
> rewrite_mode parameters. What am I missing?
>

I could however, get it to work when I passed the ORDER BY to the query itself (i.e., the re-written one), with no modifications...

SQL> select * from t0919 order by 1;

         C

         2
         4

SQL> select * from t0919 a order by 1;

         C

         1
         2

SQL> Thanks,

Steve Received on Tue Sep 19 2006 - 15:42:21 CDT