Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Need a Fast Row Count

Re: Need a Fast Row Count

From: James Hanway <hanwayj_at_NOSPAM.dfo-mpo.gc.ca>
Date: 2000/03/23
Message-ID: <38DA484F.46425F28@NOSPAM.dfo-mpo.gc.ca>#1/1

What about:

  1. select max(rownum) from table;

or

2) select count( <indexed_column> ) from table

Gary Brumfield wrote:
>
> Is there any other way than "select count(*) from <table>" to return the
> number of rows in an Oracle table? This takes forever to run (>3
> minutes) on a table that has over 3 million rows. I guess it has to do
> a full table scan to determine the correct number of rows and in a read
> consistent manner. It would be OK even if we got a count that was
> fairly close.
>
> Any Ideas or Insight?
  Received on Thu Mar 23 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US