SQL Optimization Checklist

SQL Optimization Checklist

1. If the FROM statement contains more than one table, put the table with the few records in front

2. When a where statement contains more than one condition, it will be brushed in front of many conditions

3, avoid using SELECT *, because this will be to query all columns of data, which will consume more time

4. On all fields used in the where and join parts of the SQL statement, the index should be added

5, SQL is case insensitive language, but the specification is uppercase

SQL Optimization Checklist