3 SQL tuning ideas on Table Columns to apply
3 SQL tuning ideas on Table Columns to apply
Three performance ideas of GROUP BY, IN or EXISTS and Duplicates in predicate given in this post. These ideas much useful to improve your SQL performance.
Group by
If you run a SQL query, it can consume less or more time. It all depends on how you have written the SQL. To improve performance, you need to understand the following ideas.
1. Always Use Group by
SQL Query DISTINCT vs…
View On WordPress











