Hello ! Would be nice if sqlite provide a way to create indexes in parallel, I mean when working with big tables and creating several indexes the time spent scanning the whole database/table is considerable and it's the same for each "create index", we could have a big time/cpu/disk seek saving if we could create several indexes at the same time:
CREATE INDEXES ON big_table index_1(name), index_2(title), index_3(parent), index_4(city, country); Cheers !