Re: [sqlite] Detecting table scan

Doug Nebeker wrote: 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

Re: [sqlite] Detecting table scan

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

[sqlite] Detecting table scan

I appologize for asking what might be a dumb question, but here goes: 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