Re: Where Clause Performance
You can trust the parser to analyse away obviously constant conditionals like 1=1. It's also a good general rule to not give the parser unnecessary tasks.
Query generation involves a lot of string processing. As a general rule, your application language has much a much stronger set of string processing tools than MySQL, so it's often better to wrote such query generation logic in your app language.
Subject
Views
Written By
Posted
2373
September 17, 2014 09:10PM
Re: Where Clause Performance
1072
September 18, 2014 11:11AM
1049
September 18, 2014 04:55PM
968
September 18, 2014 08:01PM
1136
September 19, 2014 03:38PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.