> -----Original Message----- > From: sqlite-users [mailto:[email protected]] On > Behalf Of Paul Sanderson > Sent: Friday, May 19, 2017 12:08 PM > To: SQLite mailing list <[email protected]> > 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
