Re: How can I count rows fast ?

From: Steve Gerard <sjg_at_qdot.qld.gov.au>
Date: 30 Jun 1994 05:36:09 GMT
Message-ID: <2utlk9$29t_at_camelot.qdot.qld.gov.au>

Michael Sallwasser (msallwas_at_world.nad.northrop.com) wrote:

: *************************************************************************
: ALERT!   ALERT!   ALERT!    ALERT!    ALERT!    ALERT!    ALERT! 

: I have heard this repeated by MANY people, including Oracle employees; : *BUT* if one does an EXPLAIN PLAN, Oracle V6 indicates it will perform a  

: >>>>>>>> FULL TABLE SCAN <<<<<<<

Our observations agree with Michael. However you can pursuade the optimiser to consider the index by changing the where clause eg add

where firstindexcolumn > 0

to your SELECT statement

Stephen Gerard
Analyst Programmer
QCOM Systems and Software
Brisbane Qld 4000
++61 7 8393544

sjg_at_avalon.qdot.qld.gov.au

<<< My thoughts and opinions only, ... etc >>> Received on Thu Jun 30 1994 - 07:36:09 CEST