开发者

Should I index DateTime in SQLite?

开发者 https://www.devze.com 2023-03-09 09:46 出处:网络
Will it make i开发者_StackOverflowt faster to find date > a certain date?In general yes, but keep in mind that SQLite only uses one index per-table (except in the case of OR clauses).Always use EXPLAI

Will it make i开发者_StackOverflowt faster to find date > a certain date?


In general yes, but keep in mind that SQLite only uses one index per-table (except in the case of OR clauses). Always use EXPLAIN to find out how the engine will process a given query.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号