16. Simple SQL optimization of MySQL partition 2

1. Classification of the index B-Tree Basic Support HASH only memory support R-Tree MyISAM Support Full-textMyISAM Support (full-text indexing)2. Under the memory engine only "="Criteria will not use the index===============================Optimization of imported data========================3How to improve the efficiency of MyISAM importAlter Tableemp disable keys; Close indexLoadData infile'Aa.sql'  into Tableemp; Import data to EMPAlter Tableemp enable keys; open Index4How to increase the import efficiency of InnoDB Import data in the order of the primary key5turn off uniqueness checks before importing dataSetUnique_checks= 0 ; Loaddata infile ....SetUnique_checks= 1; open Check===============================  InsertThe optimization========================1. Using multi-value insertsInsert  intoEmpValues(1,2,3),(1,2,3),.....===============================Optimization of pagination==========================1. Using the inner join inline2The application side does processing, the approximate idea is to record the last record of the previous page ID is how much, the next page with this ID as the starting value but this must ensure that the ID is unique