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 -> Re: Does "WHERE 0=1" require a full table scan?

Re: Does "WHERE 0=1" require a full table scan?

From: Vladimir Andreev <flado_at_imail.de>
Date: 3 Feb 2004 01:39:35 -0800
Message-ID: <7b208869.0402030139.75944042@posting.google.com>

> Indexes work by finding equality of a key to a value. Not inequality!

except bitmap indexes, of course. Nevertheless, constants are better than column names. Received on Tue Feb 03 2004 - 03:39:35 CST

This message: [ Message body ]
Next message: Tom: "Re: Post-Install: Oracle v9.2.0 on Mandrake9.2"
Previous message: Peter Gervais: "Oracle Text Problem with special characters"
Maybe in reply to: Mark D Powell: "Re: Does "WHERE 0=1" require a full table scan?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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