like 与 instr哪个效率更高一些呢？

explain SELECT c.cpny_id,c.csf_cd,l.cpny_nm  
FROM fdp.company c , fdp.company_lang l   
WHERE c.cpny_id=l.cpny_id and l.lang_cd='EN' AND INSTR(l.cpny_nm,'shanghai')>0;

explain SELECT c.cpny_id,c.csf_cd,l.cpny_nm  
FROM fdp.company c , fdp.company_lang l   
WHERE c.cpny_id=l.cpny_id and l.lang_cd='EN' AND l.cpny_nm like '%shanghai%'>0;


两者的执行计划一模一样，想问下，大家在实际oltp环境中，用instr多一些还是like多一些啊？

基本上不用like