Doug Nebeker wrote:
I have a wrapper class that I use for SQLite that I'm quite happy with. I've decided that if it is compiled for DEBUG usage, I want it to do an EXPLAIN on every SQL statement and then check the output to see if any table scans are happening (I'm just barely good enough at SQL to be dangerous). This way I'll be notified if I've got some statements or table definitions that could use some help.
Doug,
Instead of using the EXPLAIN command, use the EXPLAIN QUERY PLAN command. Its output tells you how it is scanning the tables and indexes to implement a query.
HTH Dennis Cote
