That may not be completely accurate. The accuracy of the NUM_ROWS number is dependent upon the time when statistics was generated. It the table in question is a high=traffic transactional table, and statistics was generated 2 weeks ago, you may miss the number by millions. On 02/17/2004 04:41:17 PM, Ryan wrote: > 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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- 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 -----------------------------------------------------------------