When I see Performance optimizations to reduce response times for web applications, the changes are often done at the application layer or by checking the index existence on the database table column(s). There is very less attention paid to the SQL Query tuning. Even expert architects and developers tend to forget that understanding how databases […]