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]
-----------------------------------------------------------------------------

Reply via email to