Thanks Dennis. So does that mean if I get "TABLE xyz" in the 'detail' column back and it does NOT mention an index that a full table scan is taking place? I found some info about EXPLAIN QUERY PLAN (http://www.sqlite.org/cvstrac/wiki?p=QueryPlans) but haven't found out exactly what the response columns mean.
Thanks Doug >>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 To find out more about Reuters visit www.about.reuters.com Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.
