Avoid null judgments





Do not use select *


Three, cautious use of fuzzy query


Do not use column numbers


5. Use UNION ALL instead of UNION


Avoid evaluating index fields in WHERE or ORDER by statements


7, Use not exist instead of not in


The difference between exist and in





Avoid the following operations on index columns





Ten, complex operation can consider appropriate disassembly into a few steps