Kalyani Phadke <[email protected]> wrote: > How can I see time required to run the query using Sqlite3.exe command > line utility?
There's timeit utility in Windows Resource Kit: http://www.microsoft.com/downloads/details.aspx?FamilyID=9D467A69-57FF-4AE7-96EE-B18C4790CFFD&displaylang=en > Is there any way to check if indexes are being used > while running the query Run your query prepended with EXPLAIN QUERY PLAN Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
