Re: Finding total Rows without count() ?

On Wed, 15 Dec 1999 01:43:15 -0800, bpolarsk <bpolarskNObpSPAM_at_yahoo.com.invalid> wrote:

>
>SQL> analyze table parameter estimate statistics ;
>
>Table analyzed.
>
>Elapsed: 00:00:10.27
>
>
>So the quickest way seems to be the analyze table,
>Shortly followed by select(1).

You're 'estimating' though.

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email