On 17 Jan 2018, at 6:48am, Nick <haveagoodtime2...@gmail.com> wrote: > As you said, UNIQUE(b, i) is redundant, but I guess it will not affect the > performance of the SELECT.
Correct. It’ll make the database file bigger, and it’ll slightly slow down INSERT/UPDATE/DELETE but have only a trivial effect on SELECT. > I find "SEARCH TABLE t1 USING INDEX sqlite_autoindex_t1_1 (b>?)" when I use > EXPLAIN QUERY PLAN, so I do not need to add any index, right? > > Um, I guess I have nothing to do to improve the performance. I think you got it right, and I don’t see any obvious improvement. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users