MySQL indexing rules

MySQL build index is best on the whole number of fields, the effect is more obvious

===>1.select * from goods where is_delete=0 and Status=1 and (name like ' percent ' or intro like '% ')

2. If the index is built on Is_delete and status, the speed gap is at least dozens of times times

3. The index is built on integers faster than char varchar

4. When you associate a query, it is best to associate the same field type, preferably int, because you need to design a type conversion for varchar and consume IO

Remember: do a search query once

This article is from the Linux OPS blog, so be sure to keep this source http://2853725.blog.51cto.com/2843725/1544159

MySQL indexing rules