Having been bitten by my misunderstanding of how sqlite uses indices, I would like to make a request for a feature enhancment.
Currently, explain query plan lists the index being used with each table. It would be very convenient if it would also list the columns of that index being used. Thus, when it stops using indexed columns because of an inequality, or an unused column in the index wasn't noticed, the output of explain query plan would make it quite evident. Steve Friedman _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users