How to optimize SQL query?
- Use Indexes Properly.
- Only retrieve the data you really need.(prefer using where clause)
- Avoid the use of functions in where clause.
- Avoid using SQL subqueries or nested queries. Use JOINS instead.
- Avoid Wildcard characters at the beginning of the LIKE statement.
No comments:
Post a Comment