Re: Documenation for count(*) and table scans

From: <pbolduc_at_online-can.com>
Date: Fri, 17 Apr 1998 19:41:26 -0600
Message-ID: <6h8srn$j1q$1@nnrp1.dejanews.com>

I dont know about Oracle docs, but I have read that using:

SELECT count(indexed column) ...

is about approx 5% faster that count(*).

Phil Bolduc

In article <6h7lud$21mq$1_at_rtpnews.raleigh.ibm.com>, "Jim Morgan" <jimmorgan_at_csi.com> wrote:
>
> Does anyone know where I can find Oracle documentation that talks about the
> intricacies of making count(*) use indexes to maximize performance? I've
> always sidestepped this issue somehow in my applications but now I have a
> situation where I must take care of it.
>
> I've heard conflicting information in this newsgroup and I'd like an
> official Oracle doc to get an accurate answer. I am looking for ways of
> making count(*) work efficiently when the only indexes you have defined for
> a table are compound indexes. I want to avoid doing a table scan.
>
> --
> Regards,
> Jim
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Apr 17 1998 - 20:41:26 CDT