On Tue, Jun 10, 2014 at 2:22 PM, Fabian Giesen <fabi...@radgametools.com> wrote:
> > So, is there any way to create multiple indexes for the same table in one > operation in SQLite? If not, how hard would it be to add? > Creating an index is essentially the same thing as sorting the whole table - sorting in index order. So you are going to have to sort the whole table three times, once for each index. The time to do the sort dominates. The time needed to scan the original table in order to pull out the elements is usually negligible compared to the sorting time. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users