Re: Cost explosion

On Sat, 07 Mar 1998 13:26:26 GMT, boulkenospam_at_globalnet.co.uk (Keith Boulton) wrote:

>On Wed, 04 Mar 1998 10:19:57 +0100, Stephan Schaefer
><stephan.schaefer_at_camline.com> wrote:
>
>>I have got a select statement that takes 2 seconds to compute
>>the result.
>>But I wait hours for:
>>select count(*) from ( "select_2_seconds" ) ;
>>The same happens for
>>select max(rownum) from ( "select_2_seconds" ) ;
>>and
>>create myview as select * from ( "select_2_seconds" ) ;
>
>Try issuing alter session set optimizer_goal = first_rows.
>
>This can also be specified as the optimizer_mode parameter in
>init.ora.

Some may consider this cheating, but find a method that works (RULE,CHOOSE....) in an acceptable time frame, get the explain plan for it and use hints to drive the query to that access path. Received on Sun Mar 08 1998 - 00:00:00 CST