Re: Count(*) is very slow

Well, it kicks in without being hinted in O8. I just enabled v733_plans_enabled on one of my 7.3.4 databases. Went into sql*plus, set timing on, did a select count(*0 from one of my tables, then did a hinted select count(*). The hinted query took .6 seconds.

satar_at_my-dejanews.com wrote:
: 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 Sat Oct 24 1998 - 18:09:13 CDT