SQLite Indexed By

INDEXED BY 强制查询使用指定索引,NOT INDEXED 禁用索引,用于性能调试。

Advanced
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;

Friends & Partners