Re: Index on sqlite database

> After a bit of exploring the folders.db sqlite file, I've found out
> that there is an index on every table named SINDEX-table that is an
> index for *every* column in the table.
>
> In practice, that means that the index will never be used, since it
> would require a query mixing all those fields (or at least, the first
> ones in order : uid, flags, size, .. )
>
> It also means that the index will take unnecessary place on the
> filesystem (in my case, that was around 100MB by the time I removed
> them), and slow down inserts into the database (in my case, when
> moving a lots of mails from a folder to another).