select count(*) from H_TENANT_W_2 where WINDOW_ID like '%HWG00020SESSIONKEY_WINDOWID%'
用时: 0.203秒
select count(*) from H_TENANT_W_2 where instr(WINDOW_ID ,'HWG00020SESSIONKEY_WINDOWID')>0
用时: 0.063 秒
相差 3倍多
select count(*) from H_TENANT_W_2 where WINDOW_ID like '%HWG00020SESSIONKEY_WINDOWID%'
用时: 0.203秒
select count(*) from H_TENANT_W_2 where instr(WINDOW_ID ,'HWG00020SESSIONKEY_WINDOWID')>0
用时: 0.063 秒
相差 3倍多