On 2/5/18, John Found <johnfo...@asm32.info> wrote: > > Actually I tried [adding a new index] and the query uses this index > without problems (and the > performance seems to be good). > > But what are the disadvantages of such approach? (except the bigger database > size, of course)
(1) the database file is larger. (2) When doing UPDATE on one of the columns added to the index, then the index must be updated too, in addition to the table. -- 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