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

Calm down Dave, we come here to learn. I too couldn't find fast_full_scan. But thank you for pointing out the v733_plans_enabled=TRUE. So this is the same parameter in Version 8's fast_full_scan?

In article <70ogo3$2cn$1_at_nnrp1.dejanews.com>,   smith_at_ali.com.au wrote:
> 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
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 23 1998 - 12:49:25 CDT