Re: Stored Outline Not Used

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

DA Morgan a écrit :

> thtsang_yh_at_yahoo.com.hk wrote:
> > I am maintaining an old system. One stupid SQL statement used an "IN
> > list" to select some records and relies on the output order, but it
> > does not use an order by clause! It worked with the RBO. However, if
> > CBO is used, the order is different and cause program error. I don't
> > want to modify the source code.
> >
> > OS: Redhat Enterprise 4.0
> > Oracle: 10g Release 2, 32 bit
>
> Modify the source code.
> --
> Daniel Morgan
> University of Washington
> Puget Sound Oracle Users Group
Received on Tue Sep 19 2006 - 14:13:06 CDT