Quoth Cory Nelson <phro...@gmail.com>, on 2010-09-15 20:58:24 -0700: > It sounds like you already know which columns will be queried against. > You should probably be creating permanent indexes.
I'm pretty sure his question was asking whether he could verify the set of relevant columns empirically via asking which columns would be used in the temporary index creation, for the purpose of creating permanent indices. This is useful as a secondary check even if one should theoretically know which columns will be used beforehand. ---> Drake Wilson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users