<HTML>
<HEAD>
<TITLE>STATUS of EXPLAIN Development</TITLE>
</HEAD>
<BODY>
<FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>Hi All,<BR>
<BR>
Just want to inform how far I was able go with EXPLAIN <BR>
Now it looks like this. <BR>
<BR>
Something wrong yet with JOIN info...<BR>
<BR>
----------------------------------------------<BR>
FOR SQL QUERY [] TIME = 1776 : <BR>
DO SELECT : TIME = 1776 : ROWS = 9<BR>
DO SIMPLE SELECT : TIME = 1776 : ROWS = 9<BR>
DO Single Table Without GROUP BY : TIME = 1776 : ROWS = 9<BR>
DO Build JoinTable : TIME = 1776 : ROWS = 9<BR>
DO For each Table from 7 resolve its WHERE conditions : TIME = 1 : <BR>
FOR Table [birdrecords] DO SelectAllRecords : TIME = 0 : ROWS = 32268<BR>
FOR Table [locations] DO SelectAllRecords : TIME = 0 : ROWS = 1263<BR>
FOR Table [species] DO SelectAllRecords : TIME = 0 : ROWS = 1011<BR>
FOR Table [geozones] DO SelectAllRecords : TIME = 0 : ROWS = 8<BR>
FOR Table [statetable] DO resolve WHERE statement : TIME = 1 : ROWS = 1<BR>
FOR Field [state] DO FindValue(NC) : TIME = 1 : ROWS = 1<BR>
FOR Table [speciesforms] DO SelectAllRecords : TIME = 0 : ROWS = 37<BR>
FOR Table [sourcetable] DO SelectAllRecords : TIME = 0 : ROWS = 9<BR>
<BR>
DO JOIN of 2 Tables : TIME = 402 : ROWS = 24112<BR>
<BR>
<BR>
-- <BR>
Best regards,<BR>
<BR>
Ruslan Zasukhin<BR>
VP Engineering and New Technology<BR>
Paradigma Software, Inc<BR>
<BR>
Valentina - Joining Worlds of Information <BR>
<a href="http://www.paradigmasoft.com">http://www.paradigmasoft.com</a><BR>
<BR>
[I feel the need: the need for speed]<BR>
</SPAN></FONT>
</BODY>
</HTML>