| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Counting number of rows
Still alive (without life), very busy!
I couldn't resist this one although I knew it was coming based on the trend
of your previous emails last two weeks :)
Regards,
Waleed
-----Original Message-----
From: Mladen Gogala [mailto:mladen_at_wangtrading.com]
Sent: Tuesday, February 17, 2004 5:25 PM
To: oracle-l_at_freelists.org
Subject: Re: Counting number of rows
Waleed, I haven't seen you on the list for a long time. If writing a function like that was what it takes to get you back, it was more then worth it.
On 02/17/2004 04:55:53 PM, "Khedr, Waleed" wrote:
> It did not work for me, for some reason it always returns zero
>
> Waleed
>
> -----Original Message-----
> From: Mladen Gogala [mailto:mladen_at_wangtrading.com]
> Sent: Tuesday, February 17, 2004 4:15 PM
> To: oracle-l_at_freelists.org
> 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/
> > --------------------------------------------------------
> >
> >
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_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 - 16:42:37 CST
 |
 |