Re: Count(*) is very slow (7.3.3)

From: <smith_at_ali.com.au>
Date: Thu, 22 Oct 1998 23:56:51 GMT
Message-ID: <70ogo3$2cn$1@nnrp1.dejanews.com>

Thanks for saying that I'm full of shit!

In v 7.3.3 the parameter is

v733_plans_enabled=TRUE

See

http://www.oramag.com/oracle/98-Jul/dba.html

In article <70n2up$n9d$1_at_hermes.is.co.za>, "Billy Verreynne" <vslabs_at_onwe.co.za> wrote:
> Andreas Kyritz wrote in message <70mv73$p34$1_at_news.ipf.net>...
>
> >I've got a mail with the right idea from Dave Smith from Australia.
> >The trick to do 'SELECT COUNT(*) FROM ATABLE' fast is, to include:
> > fast_full_scan_enabled=true
> >to the init file.
> >That's all and now it takes less than a second. 8-))
>
> Well methinks that someone is bullshitting someone 'cause there aint no
> such thing with v7.x....
>
> Is this a v8.x parameter? Comments?
>
> regards,
> Billy
>
>

--
Dave Smith

smith_at_ali.com.au

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 22 1998 - 18:56:51 CDT