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: Record row count and execution time into table?

Re: Record row count and execution time into table?

From: Niall Litchfield <Niall.litchfield_at_dial.pipex.com>
Date: Sun, 02 Oct 2005 17:28:14 +0100
Message-ID: <43400A9E.8030009@dial.pipex.com> 





www.twisted-nail.com wrote:


> Hi,

> 

> Counting the rows in the table is performed by full table scan. 




Unless it is done via an index. bitmap or normal indexes can, but don't 
necessarily, provide the best access path for a count(*).


-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com


Received on Sun Oct 02 2005 - 11:28:14 CDT












Original text of this message













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