如何创建并强制使用索引 ■语法 ◆创建索引 creat index index_name on table_name(column_name); ◆强制使用索引查询 •在SQLite中: select * from table_name(创建索引的表) indexed by index_name where condition •在Mysql中: select * from table_name(创建索引的表)FORCE INDEX (索引名) where condition