Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Count(*) is very slow

Re: Count(*) is very slow

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 22 Oct 1998 12:53:22 +0200
Message-ID: <70n2up$n9d$1@hermes.is.co.za>


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 Received on Thu Oct 22 1998 - 05:53:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US