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 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. So, I started looking through the list of opcodes (www.sqlite.org/opcode.html) and it is not at all obvious to me how to detect that a table scan will take place. Do I just look for OpenXXX opcodes?? One other completely unrelated question: How often do any of you run ANALYZE on your databases? Any rules of thumb for when to do it? Thanks Doug
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.
