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

"zhao" <zhaohui_at_goconnect.net> wrote in message news:<3f73876f$0$95051$c30e37c6_at_lon-reader.news.telstra.net>...
> 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

/* OracleOEM */ SELECT to_char(last_analyzed,'DD-MON-YYYY HH24:MI'),blocks,empty_blocks,avg_space,num_rows, sample_size,avg_row_len,chain_cnt,avg_space_freelist_blocks, num_freelist_blocks from sys.dba_tables WHERE owner = 'SCOTT' AND table_name = 'EMP';

jg

--
@home.com is bogus.
"Fast and Bulbous."  - Captain Beefheart