db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Question regarding runtimestatistics and join order
Date Thu, 02 Oct 2008 18:08:38 GMT
Kathey Marsden <kmarsdenderby@sbcglobal.net> writes:

> Army wrote:
>>
>> As a general rule, when looking at a given query plan the join order
>> is reflected by the order in which you see the table names as you
>> scroll from the top of the plan downward.
>>
> As for how to incorporate this into RuntimeStatisticsParser, the only
> thing I can think of is to add an boolean
> orderedSearchStrings(String[] searchStrings) method to
> RuntimeStatistics parser that will search for the specified strings in
> order and return true if they are there in the order they are in the
> array.

Or change the runtime statistics output to something that's easier to
parse. Sexp or XML or something... :)

-- 
Knut Anders

Mime
View raw message