SQLite Indexed By
INDEXED BY 强制查询使用指定索引,NOT INDEXED 禁用索引,用于性能调试。
Key PointsSQLite,INDEXED BY,NOT INDEXED,强制索引
讲解
INDEXED BY 强制查询使用指定索引,NOT INDEXED 禁用索引,用于性能调试。
示例
SQL
SELECT * FROM company INDEXED BY idx_company_name WHERE name = 'Google';
SELECT * FROM company NOT INDEXED WHERE age > 20;讲解
INDEXED BY 强制查询使用指定索引,NOT INDEXED 禁用索引,用于性能调试。
示例
SQL
SELECT * FROM company INDEXED BY idx_company_name WHERE name = 'Google';
SELECT * FROM company NOT INDEXED WHERE age > 20;