| 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.html
Received on Mon Aug 28 2000 - 17:25:39 CDT
![]() |
![]() |