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...
Jul 30, 20232 min read36
