Re: Any way to get RowCount by not using Select count(*) from table

After analyzing the table to this:

select num_rows from dba_tables where table_name = 'xxx...' ....

Regards

Jonathan Ingram <jonathan.ingram_at_miname.com> wrote in article <368957E5.E61F829_at_miname.com>...
> boonsong wrote:
>
> > Any way to get RowCound by not using Select count(*) from table
>
> Yes. Don't select count (*); instead, do one of the following:
>
> select count (1) from <table>;
> select count (rowid) from <table>;
>
> Jonathan
>
>
>
Received on Sun Jan 03 1999 - 21:02:02 CST