索引

select * from d_storage_out_info d where d.soi_amount>30

alter table d_storage_out_info add index(soi_amount)
show index from d_storage_out_info

alter table d_storage_out_info drop index soi_amount
//drop index soi_amount on d_storage_out_info