> -----Original Message----- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Paul Sanderson > Sent: Friday, May 19, 2017 12:08 PM > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Subject: Re: [sqlite] auntondex with unique and integer primary key
> I just thought it might be an area for optimisation as a redundant index is > built. According to the docs, it's only a pointer and not a duplicate when specified exactly as 'INTEGER PRIMARY KEY'. The semantics change when you add AUTOINCREMENT to it. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
