Thanks for the article, really useful. I have an observation regarding the item 10. Avoid OR conditions on frequently used queries. You mentioned that it is an OR condition, but your snippet used an AND, like this
OR
AND
(...) WHERE FIRST_NAME LIKE 'Kim%' AND EMAIL Like 'kim%.org';
I thought it is a typo and may you wanna fix that.
Glad you liked it. Yes it is 'OR', thanks for pointing it out! Changed it.
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Thanks for the article, really useful.
I have an observation regarding the item 10. Avoid OR conditions on frequently used queries.
You mentioned that it is an
ORcondition, but your snippet used anAND, like thisI thought it is a typo and may you wanna fix that.
Glad you liked it.
Yes it is 'OR', thanks for pointing it out! Changed it.