Re: number of rows in a table

I would suggest you to do the following.

create a spool file from sql plus
then select 'analyze table ' || Table_name || ' compute statistics;' from user_tables;
run the spooled file.

Now look into user_tables. You will also have the number of rows in the table. Mail me at shanki_at_excite.com if you have more questions

Shanki
suja_raja_at_my-dejanews.com wrote in message <7gkjr5$7en$1_at_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 - 14:25:19 CDT