On 5/19/17, Paul Sanderson <sandersonforens...@gmail.com> wrote: > > Yes Unique is redundant in the create statement, but it would be a small > optimisation, unless I am missing something, for SQLite to detect this and > not create the autoindex to start with. >
That would be great, if we had caught the problem 15 years ago. But now, we have to keep the databases backwards compatible, and omitting the index would generate an incompatible database file. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users