STATUS of EXPLAIN Development

[Ruslan Zasukhin]

Hi All,

Just want to inform how far I was able go with EXPLAIN
Now it looks like this.

Something wrong yet with JOIN info...

----------------------------------------------
FOR SQL QUERY [] TIME = 1776 :
     DO SELECT : TIME = 1776 : ROWS = 9
         DO SIMPLE SELECT : TIME = 1776 : ROWS = 9
             DO Single Table Without GROUP BY : TIME = 1776 : ROWS = 9
                 DO Build JoinTable : TIME = 1776 : ROWS = 9
                     DO For each Table from 7 resolve its WHERE conditions :
TIME = 1 : 
                        FOR Table [birdrecords]  DO SelectAllRecords : TIME
= 0 : ROWS = 32268
                        FOR Table [locations]  DO SelectAllRecords : TIME =
0 : ROWS = 1263
                        FOR Table [species]  DO SelectAllRecords : TIME = 0
: ROWS = 1011
                        FOR Table [geozones]  DO SelectAllRecords : TIME = 0
: ROWS = 8
                        FOR Table [statetable]  DO resolve WHERE statement :
TIME = 1 : ROWS = 1
                            FOR Field [state]  DO FindValue(NC) : TIME = 1 :
ROWS = 1
                        FOR Table [speciesforms]  DO SelectAllRecords : TIME
= 0 : ROWS = 37
                        FOR Table [sourcetable]  DO SelectAllRecords : TIME
= 0 : ROWS = 9

                     DO JOIN of 2 Tables : TIME = 402 : ROWS = 24112


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]