Re: Count(*) is very slow

From: <satar_at_my-dejanews.com>
Date: Thu, 22 Oct 1998 21:02:35 GMT
Message-ID: <70o6hb$na3$1@nnrp1.dejanews.com>

Yeah, I think this is either an Undercover parameter, or only in version 8.

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
>
>

--
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 Thu Oct 22 1998 - 16:02:35 CDT