Re: number of rows in a table

From: <suja_raja_at_my-dejanews.com>
Date: Mon, 03 May 1999 16:45:27 GMT
Message-ID: <7gkjr5$7en$1@nnrp1.dejanews.com>

Hi,

I have never tried this with large tables, but I suggest U can try.

SELECT MAX(ROWNUM) FROM table;

or instead of COUNT(*), try COUNT(primarykey)

Hope this helps.

Sujatha.

In article <372DA0DD.DA8A3A22_at_probanka.si>, sunil.jayasinghe_at_probanka.si wrote:
> Hi
> Is there a (faster)way to find out number of rows in a table
> other than select count(*) from table?
>
> Thanks
> --
> ____________________________________________________________________
>
> Sunil Jayasinghe E-mail: sunil.jayasinghe_at_probanka.si
> PROBANKA d.d. Tel: +386 62 22 94 881
> Gosposka 23 Fax: +386 62 22 58 82
> 2ooo Maribor, Slovenia WWW: http://www.probanka.si
> ____________________________________________________________________
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon May 03 1999 - 11:45:27 CDT