Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Where clause "where 1=1" help with SQL tuning

oracle_developerOct 8 2012 — edited Oct 10 2012
Hello Tuning experts,
Is it helpful to use "where 1=1" and then put all the joins and conditions in the "AND" statements of the SQL when writing SQL queries. I would like to know if it helps with query performance to write SQL queirs that way.

Thanks in advance.

Edited by: oracle_developer on Oct 8, 2012 10:41 AM
This post has been answered by sb92075 on Oct 8 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2012
Added on Oct 8 2012
#performance, #tuning
11 comments
1,443 views