Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Will Oracle scan the table with this query?
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.htmlReceived on Mon Aug 28 2000 - 17:25:39 CDT