How do you describe how SQL statement performance is analyzed in terms of how you can optimize the efficiency of SQL statement execution in your project?

(1) Try to select smaller columns;

(2) to index the more frequent fields in where;

(3) Avoid using * in select;

(4) Avoid the use of calculations, not-in and <> operations on indexed columns;

(5) Use limit1 when only one row of data is needed;

(6) To ensure that the single-table data does not exceed 200w, real-time partition table;

For a slow query, you can use explain to analyze the statement's specific execution.

How do you describe how SQL statement performance is analyzed in terms of how you can optimize the efficiency of SQL statement execution in your project?