Re: Will Oracle scan the table with this query?

I've just testet ot and the anser was no: SQL> select * from items where 1=0;

Es wurden keine Zeilen ausgewählt (no recs selected)

Abgelaufen: 00:00:00.00 (Time)
SQL> Items has about 2mio recs

>
> 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 - 18:03:02 CDT