We do analyze some schemas daily. So I will use num_rows. Thanks to all that responded. > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [SMTP:oracle-l-bounce@xxxxxxxxxxxxx] On > Behalf Of Ryan > Sent: Tuesday, February 17, 2004 4:41 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: Re: Counting number of rows > > if the table is analyzed just go to dba_Tables.num_rows > > bitmap indexes are very fast on counts. > ----- Original Message ----- > From: "Mladen Gogala" <mladen@xxxxxxxxxxxxxxx> > To: <oracle-l@xxxxxxxxxxxxx> > Sent: Tuesday, February 17, 2004 4:15 PM > Subject: Re: Counting number of rows > > > > The function below would count rows extremely quickly, and is > > independent of the table size. Even better, it is completely accurate > > and doesn't rely on the underlying statistics. The table > > in question may not even be analyzed. It does have one minor > > shortcoming, however. > > > > <PRANK> > > create or replace > > function count_rows(tbl in varchar2) return number deterministic > > as > > TRUNC VARCHAR2(128):='truncate table '||tbl; > > begin > > execute immediate trunc; > > return(0); > > end; > > / > > </PRANK> > > On 02/17/2004 03:27:31 PM, "Potluri, Venu (CT Appl Suppt)" wrote: > > > 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. > > > -------------------------------------------------------- > > > > > > 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/ > > > -------------------------------------------------------- > > > > > > > ============================================================================ > == > > > > > > 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/> > > > > > > > ============================================================================ > == > > > > > > ---------------------------------------------------------------- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > ---------------------------------------------------------------- > > > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > > > put 'unsubscribe' in the subject line. > > > -- > > > Archives are at //www.freelists.org/archives/oracle-l/ > > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > > > ----------------------------------------------------------------- > > > > > ---------------------------------------------------------------- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > ---------------------------------------------------------------- > > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > > put 'unsubscribe' in the subject line. > > -- > > Archives are at //www.freelists.org/archives/oracle-l/ > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > > ----------------------------------------------------------------- > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > -----------------------------------------------------------------> -------------------------------------------------------- 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/ -------------------------------------------------------- ============================================================================== 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/> ============================================================================== ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------