В сообщении от Friday 13 June 2008 20:38:42 Andrew Brampton написал(а): > Hi Donald, > > I have a index on both lat and long, but please correct me if I'm wrong, > but I think SQLite will only use a single index per SELECT. So only one of > the index is in use. I think the EXPLAIN command confirms this for me.
You can use multiple indices as http://www.mail-archive.com/sqlite-users%40sqlite.org/msg27224.html _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
