So I've been using EXPLAIN QUERY PLAN to try to optimize my queries,
and I realized I'm missing something important.
It shares what tables are used and what indexes, but as I understand
it, it doesn't include whether I'm working entirely off indexes or
not. For instance, if I have a line:
TABLE Groups WITH INDEX GroupTypeIndex
...does that indicate if GroupTypeIndex fully satisfies the search?
How can I tell this?
What'd be great is if explain query plan had another column that
indicated which columns it had to crawl through...
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------