| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Count(*) is very slow
On Thu, 22 Oct 1998 12:53:22 +0200, "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?
This particular init parameter is realy new to Oracle8, but "fast full-index scan" is available with Oracle 7.3.3 and above. There is even a new hint "INDEX_FFS (table, index)" to force a fast full-index scan. There was a very good article by Guy Harrison about this new future in one of the recent Oracle Magazines, and it is available online http://www.oramag.com/oracle/98-Jul/dba.html
>regards,
>Billy
Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)
 |
 |