Forgot the list CC.
--- Begin Message ---
On Tue, Feb 03, 2004 at 12:45:29PM +0100, Schroeder, Alexander wrote:
> Aside from the issue in the optimizer - why would a change in the JVM change an SQL
> Statement?
Different iterator strategies maybe? The generation of the statements is
hidden away in the persistance framework. But the result _should_ be the
same.
> The hint is obviously specifying the tables in the same order, and of course keeping
> the table statistics up-to-date.
The statistics are up-to-date. Why should the order of the tables (the
statement is equivalent, dont you agree?) matter? If the EXPLAIN Plan is
the same, i expect both statements to produce the same behaviour ...
Puzzled,
Dirk
--- End Message ---
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
