Quoth Max Vlasov <max.vla...@gmail.com>, on 2010-09-11 22:16:14 +0400: > although index at least should not be worse in any situation
I wouldn't be quite so sure. Would there not be use cases in which different sets of columns from the same rows were selected in queries close together, such that reading from the main table data repeatedly would have better pager cache locality than reading from different indices based on which columns were wanted? Granted, that may be an uncommon case, but it seems worth considering such cases given the (apparent) complexity cost of adding index reads to the compiled query when an index would not otherwise be used. > Max ---> Drake Wilson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
