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
sqlite-users mailing list