sql">-- 默认索引
create index idx_points on customers (points);
select customer_id
from customers
where points>1000;

sql">--前缀索引
create index idx_last_name on customers (last_name(5));
select customer_id
from customers
where last_name like 'boa%';

sql">-- 全文索引
create fulltext index idx_title_body on posts(title,body);
select *,match(title,body) against ('react redux')
from posts
-- where match (全文索引的列名(所有)) against(关键词)-- where match(title,body) against ('react redux')	
-- 表示包含 'react' 或 'redux' 的记录where match(title,body) against('react -redux +form' in boolean mode) 
-- 表示包含 'react' ，不包含 'redux'，必须包含'form' 的记录

sql">-- 复合索引
create index idx_state_points on customers (state,points);
explain select customer_id
from customers
where state='ca' and points>1000;