Re: Finding total Rows without count() ?

From: Kurt Harless <kharless_at_styl.com>
Date: Wed, 15 Dec 1999 08:35:28 -0700
Message-ID: <838cqr$h9k$1@nnrp03.primenet.com>

Note...

Instead of doing a count(*) use count('x'), or any literal, this prevents the parser from having to determine the columns for the query. This speeds up count a bit.

Kurt

Ken Sproule <kenmn_at_tds.net> wrote in message news:brrd5s8pcpj2mo80gbjtsc2mmf99n7ppcc_at_4ax.com...
> As always, thanks in advance for your help.
>
> I need a fast way to determine the total number of rows in a table. I
> assume somewhere Oracle stores such information about its tables.
> Where is it?
>
> The count() type syntaxes take much too long on tables of say 3+
> million rows, so I'm looking for a fast way to accomplish it.
>
> Post answers to the group, as others might be interested also.
>
> Thanks,
>
> Ken Sproule
> kenmn_at_tds.net
>
>
Received on Wed Dec 15 1999 - 09:35:28 CST