Re: Cost explosion

From: Keith Boulton <boulkenospam_at_globalnet.co.uk>
Date: 1998/03/07
Message-ID: <35013915.5380296@read.news.global.net.uk>#1/1

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. Received on Sat Mar 07 1998 - 00:00:00 CST