On 14 Aug 2017, at 7:00am, J Decker <d3c...@gmail.com> wrote:
> Also, is a unique constraint also an index? Your thinking is correct. SQLite creates an index for internal use when you declare that something must be UNIQUE. SQLite is usually clever enough to use this index for other purposes when it would speed things up. So there’s no point in declaring your own identical index. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
