> -----Original Message----- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Paul Sanderson > Sent: Friday, May 19, 2017 11:22 AM > To: General Discussion of SQLite Database <sqlite- > us...@mailinglists.sqlite.org> > Subject: [sqlite] auntondex with unique and integer primary key
> Is the autoindex redundant and is this an opportunity for optimisation? See https://sqlite.org/autoinc.html and https://www.sqlite.org/rowidtable.html for the nuances and rational for one versus the other. Hth, jlc _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users