RE: Why "where 1=1" gives more performance?

RE: Why "where 1=1" gives more performance?

 

  

Could be it's altered the access path for the better.
Trace the query with and without the 1=1 and check the difference (if any).
It could also be that the data you were querying was in the buffer cache for
you 1=1 query, so would be much quicker.

Michael Peel

-----Original Message-----
From: Van den Bosch Bart
[mailto:oracledba-ezmlmshield-x70361274.[Email address protected]
Sent: 26 May 2008 16:48
To: LazyDBA Discussion
Subject: RE: Why "where 1=1" gives more performance?


Jayashree Mohanty,

I use such a condition from time to time but never for performance
reasons.
It's just a fine way to add the relevant conditions dynamically.

Bart Van den Bosch


-----Original Message-----
From: Jayashree Mohanty
[mailto:oracledba-ezmlmshield-x39556217.[Email address protected]
Sent: vrijdag 23 mei 2008 6:49
To: LazyDBA Discussion
Subject: Why "where 1=1" gives more performance?

Hi Ds



Appreciate for the response to "why "where 1=1" performs well in a
oracle query?"





Best Regards

Jayashree Mohanty





DISCLAIMER:
This email may contain confidential or privileged information for the
intended recipient(s) and the views expressed in the same are not
necessarily the views of Zensar Technologies Ltd. If you are not the
intended recipient or have received this e-mail by error, its use is
strictly prohibited, please delete the e-mail and notify the sender.
Zensar Technologies Ltd. does not accept any liability for virus
infected mails.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



______________________________________________________________________

This e-mail and all files transmitted as attachment(s) thereto are
confidential and solely intended for the individual to whom or the
organization to which they are addressed.

If you received this e-mail by mistake, please notify Cegeka’s system
manager at [Email address protected] or call +32 (0)11 240 363. We thank you
in advance.

Cegeka hereby confirms that this message has been swept by Sophos for the
presence of viruses.
______________________________________________________________________



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ

AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************


Oracle LazyDBA home page