On Thu, 20 Dec 2007 11:27:37 -0800, Steven Fisher <[EMAIL PROTECTED]> wrote:
>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... EXPLAIN QUERY PLAN SELECT ... only shows which access strategy the optimizer has chosen. You will get much more detail with EXPLAIN SELECT ... It shows the VDBE code, which looks cryptic at first but will prove really informative. -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
