Re: What's fast way to get total of records

zhao wrote:

>Hi,
>
>Can someone tell me what's fast way to get total of records in a table
>except using "select count(*)" statement? Can I get the information from a
>system table?
>
>Thanks,
>
>Andy
>
>

There is no other way.

You could obtain it from the all_tables view, of course, but the value will not be present if statistics haven't been run and will be inaccurate if any changes have taken place since the last time statistics have been run.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)