金融其它 sql优化
如何优化like '%db2china%'这种谓词的SQL查询
众所周知,这种语句走不了索引,那么我们该如何尽可能优化该语句
select d.aid, d.name, d.article from db2china where d.name like '%chao%'
select d.aid, d.name, d.article from db2china where d.name like '%chao%'