Re: alternative to select count(*) for oracle 8
From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Thu, 24 Apr 2003 12:07:14 +0200
Message-ID: <1051178504.622482_at_news.thyssen.com>
Date: Thu, 24 Apr 2003 12:07:14 +0200
Message-ID: <1051178504.622482_at_news.thyssen.com>
"John Leslie" <johnleslie_at_madasafish.com> wrote...
Hi John,
if you have statistics up to date, you can take a look at the column
'num_rows' in sys.user_tables.
hth,
> Is there a better way to get the number of rows in a table, other than
> using select count(*). For example, is there a dictionary table I can
> read to accurately get the number of rows in a table?
>
> John
Guido
Received on Thu Apr 24 2003 - 12:07:14 CEST