RE: Counting number of rows

From: Thomas Biju <BThomas_at_br-inc.com>
Date: Tue, 17 Feb 2004 14:31:38 -0600
Message-ID: <75DFF91B31A1284992092BDB70C9232401ABDF55@ftwp45ns.br-inc.net>

Well, if you're not very particular about the exact number of rows, you may=  select from DBA_TABLES, the NUM_ROWS column (after the table is analyzed).

-----Original Message-----
From: Potluri, Venu (CT Appl Suppt) [mailto:venu_potluri_at_ml.com] Sent: Tuesday, February 17, 2004 2:28 PM To: oracle-l_at_freelists.org
Subject: Counting number of rows

Is there a quick way to count number of rows in a table? Don't want to do s= elect count(*) from..... on a table (such as GL_BALANCES) with more than 250 million rows.=20

---

=20

If you are not an intended recipient of this e-mail, please notify the send= er, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relati= ng to this e-mail. http://www.ml.com/email_terms/=20

---

=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it.

Click here for important additional terms relating to this e-mail.

     <http://www.ml.com/email_terms/>

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

---

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
-----------------------------------------------------------------


___________________________________________________________________________=
__________________________________

This electronic transmission and any attached files are intended solely for=
 the person or entity to which they are addressed and may contain informati=
on that is privileged, confidential or otherwise protected from disclosure.=
 Any review, retransmission, dissemination or other use, including taking a=
ny action concerning this information by anyone other than the named recipi=
ent, is strictly prohibited. If you are not the intended recipient or have =
received this communication in error, please immediately notify the sender =
and destroy this communication.
----------------------------------------------------------------
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:31:38 CST