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 -> Will Oracle scan the table with this query?

Will Oracle scan the table with this query?

From: Joseph Weinstein <joe_at_weblogic.com>
Date: Mon, 28 Aug 2000 15:25:39 -0700
Message-ID: <39AAE6E3.ED579B76@weblogic.com>

Hi all. With

SELECT * FROM BIGTABLE WHERE 1 = 0 will Oracle waste the time visiting all the data? Thanks,
Joe


                    The Weblogic Application Server from BEA                     
         JavaWorld Editor's Choice Award: Best Web Application Server
  Java Developer's Journal Editor's Choice Award: Best Web Application Server
     Crossroads A-List Award: Rapid Application Development Tools for Java     
Intelligent Enterprise RealWare: Best Application Using a Component Architecture
                 http://www.bea.com/press/awards_weblogic.html
Received on Mon Aug 28 2000 - 17:25:39 CDT

Original text of this message

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