是否添加假造列 | 执行sql | 耗时 |
否 | select * from test_table where company_id = 6 and mobile like '%1800'; | 109 rows retrieved starting from 1 in 5 s 83 ms (execution: 2 s 911 ms, fetching: 2 s 172 ms) |
是 | select * from test_table where company_id = 6 and right4Mobile = '1800'; | 109 rows retrieved starting from 1 in 160 ms (execution: 72 ms, fetching: 88 ms) |
欢迎光临 ToB企服应用市场:ToB评测及商务社交产业平台 (https://dis.qidao123.com/) | Powered by Discuz! X3.4 |