On 5/19/17, Paul Sanderson <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
