RE: Counting number of rows

From: Whittle Jerome Contr NCI <Jerome.Whittle_at_scott.af.mil>
Date: Tue, 17 Feb 2004 14:37:21 -0600
Message-ID: <DFEC3C69DE8C524DA705BC09A220740B0269787D@AMCW2VN801.amc.ds.af.mil>

If you don't need to be 100% accurate AND have analyzed that table with compute statistics recently: SELECT num_rows
FROM DBA_TABLES
WHERE table_name ='GL_BALANCES';

Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145

> -----Original Message-----
> From: Potluri, Venu (CT Appl Suppt) [SMTP:venu_potluri_at_ml.com]
>
> Is there a quick way to count number of rows in a table? Don't want to do select count(*) from..... on a table (such as GL_BALANCES) with more than 250 million rows.
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Feb 17 2004 - 14:37:21 CST