Should I index DateTime in SQLite?
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.
加载中,请稍侯......
精彩评论