Re: Avoiding table or index access at all

From: Robert Klemme <bob.news_at_gmx.net>
Date: Wed, 25 May 2005 17:07:16 +0200
Message-ID: <3fjil8F86jqkU1@individual.net>

Tony Andrews wrote:
> nomorekiss_at_gmail.com wrote:

>> To be more specific:
>> The query selects from all_objects and I would like it not to return
>> any rows and not to perform and activity at all.

>
> WHERE 1=0
This is insecure: 1 and 0 are too close. Better use WHERE 1000=-1000 ;-)

    robert Received on Wed May 25 2005 - 10:07:16 CDT