DEV Community

Discussion on: 10 Ways to optimise your Database queries

Collapse
leokassio profile image
~:$ leokassio

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

(...)
WHERE FIRST_NAME LIKE 'Kim%'
AND EMAIL Like 'kim%.org';
Enter fullscreen mode Exit fullscreen mode

I thought it is a typo and may you wanna fix that.

Collapse
ktnl profile image
Nithyalakshmi Kamalakkannan Author

Glad you liked it.
Yes it is 'OR', thanks for pointing it out! Changed it.