Learn how to optimize SQL queries for faster and more memory efficient execution. Topics include using EXIST() instead of COUNT(), using varchar instead of char, avoiding subqueries in WHERE clause, ordering JOINs from a larger table to a smaller table, and using regexp_like instead of LIKE clause.
Table of contents
1. Use EXIST() instead of COUNT() to find a Specific Element in the Table2. Use of Varchar instead of Char3. Avoid Subqueries in WHERE Clause4. Ordering JOINs from a Larger Table to a Smaller Table5. Use `regexp_like` instead of `LIKE` ClauseConclusion2 Comments
Sort: