You may want to put the columns with the highest selectivity first in
your index.
The device 15 has nearly 100000 entries in the table while the remaining of
the 600 Million records belong to another device.
E.g., CREATE INDEX map_index ON map (d, ...);
Also, you should run ANALYZE map so that the query planner has accurate
information about your index.
Fabian
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users