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.
精彩评论