SQL Optimization Tips/Questions

Below are some of the tips for SQL query optimizations in the form of question/answers. 1. Which of the following query is the most optimized? a. SELECT column_name FROM table_name WHERE LOWER(column_name) = ‘name’. b. SELECT column_name FROM table_name WHERE column_name = ‘NAME’ or column_name = ‘name’. c. SELECT * FROM table_name WHERE LOWER(column_name) = [...] Read more »