Optimized SQL Queries for Daily Use !
1. Use ‘regexp_like’ to replace ‘LIKE’ clauses
Normal Query -
SELECT *
FROM
table1
WHERE
lower(item_name) LIKE '%Table%' OR
lower(item_name) LIKE '%Chair%' OR
lower(item_name) LIKE '%Bed%' OR
lower(item_name) LIKE '%Fan%'
--and so on
Optimized Query...
theanalystgeek.hashnode.dev2 min read