I've uploaded 'idxchk' to the contrib section of the SQLite website. idxchk is a small utility that prints index usage for a query statement. I have also authored a corresponding Wiki page for idxchk documentation, and an example of using idxchk by adding indexes to improve query performance.
idxchk is written in Tcl, and runs on Unix, Linux, and Windows. See the Wiki page for details: http://www.sqlite.org/cvstrac/wiki?p=IdxChk http://www.sqlite.org/contrib Comments welcome, but note that I'll be out of town through the middle of next week, so I may not be able to reply right away. Enjoy! -- Tom Poindexter [EMAIL PROTECTED] http://www.nyx.net/~tpoindex/
