sqlite index checker

http://www.sqlite.org/cvstrac/wiki?p=IdxChk

dxchk (index check) is a Tcl program that analyzes a SELECT (or other) SQL statement and prints which indexes are used.

You must install TCL and sqlite first. The other imporant package is SQLITE with TEA (Tcl Extension Architecture).
SQLITE with TEA is under download pages of sqlite