sqlite 强制使用某个索引(不是force index)
SELECT * FROM COMPANY INDEXED BY salary_index WHERE salary > 5000;
INDEXED BY salary_index
这个才是sqlite的用法
参考:https://www.runoob.com/sqlite/sqlite-indexed-by.html
SELECT * FROM COMPANY INDEXED BY salary_index WHERE salary > 5000;
INDEXED BY salary_index
这个才是sqlite的用法
参考:https://www.runoob.com/sqlite/sqlite-indexed-by.html