Re: Counting number of rows
- From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 17 Feb 2004 23:41:21 +0100
Hi,
there is possibility of tuning this count function! Use simple truncate with
REUSE STORAGE!
Some extent processing will be omitted.
D.B.Nemec
PS: to restore the table is insert /*+ append */ the optimal solution!
----- Original Message -----
From: "Mladen Gogala" <mladen@xxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, February 17, 2004 10: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
-----------------------------------------------------------------
Other related posts:
