提高sql查询性能-使用instr函数替换like

select f1.htbh as "htbh",f2.syqr as "cqr",f1.fwzl as "cqzl"
        from FCJY_CLF_MMHT f1
        join FCJY_CLF_MMHT_FWQSGK f2
        on f1.htid = f2.htid
        where f1.htbh like '%1%';

select f1.htbh as "htbh",f2.syqr as "cqr",f1.fwzl as "cqzl"
        from FCJY_CLF_MMHT f1
        join FCJY_CLF_MMHT_FWQSGK f2
        on f1.htid = f2.htid
        where instr(f1.htbh,'1)>0;