Home » SQL & PL/SQL » SQL & PL/SQL » Where 1 = 2
Where 1 = 2 [message #19983] Mon, 22 April 2002 14:08 Go to next message
Hernan Cabrera
Messages: 1
Registered: April 2002
Junior Member
Hi,

Just a quick question...

Does a condition like Where 1 = 2 causes a full scan on the table?

Thanks on advance.

Hernan Cabrera P.

Report message to a moderator

Re: Where 1 = 2 [message #19989 is a reply to message #19983] Tue, 23 April 2002 01:21 Go to previous message
John R
Messages: 156
Registered: March 2000
Senior Member
Not as far as I can tell.

If you have other Where clauses that would allow indices to be used then they still will be.

Report message to a moderator

Previous Topic: pl/sql-equation
Next Topic: Invalid data in Date fields!?!?!?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 23:14:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.