Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Count(*) is very slow
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