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 12:47:28 GMT
Manjula Kutty <manjula.kutty@gmail.com> writes:

> Thanks for the reply Mamta. But the thing is I could not find the
> specic join order in the runstime statistics plan. May be I don't know
> how ot read it? In the given plan did you find anything about the join
> order??

Hi Manjula,

I think the join order is T1, T3. Under Hash Join ResultSet, the plan
says that the left result set is a Distinct Scan ResultSet for T1, and
the right result set is a Hash Table ResultSet whose source result set
is a Distinct Scan ResultSet for T3.

Knut Anders

View raw message