RE: SQL table joins: Join vs. Where

> From: Vern Hamberg
> 
> Jay, interesting results.
> 
> I am interested in the optimizer messages for each case. Just STRDBG
with
> no program name, then run the SQL.

A good alternative would be to get the test over on the IAAI site and
then anybody who wanted to could download the programs and run them on
their own machine and report the results.


> Also, did you run them in the same order for all tests? And did you
> SETOBJACC *PURGE & CLRPOOL between runs, so that there was no data
left in
> memory? This is necessary to compare apples to apples when doing unit
> tests such as this.

"Necessary" depends highly on what you're trying to prove, but feel free
to come on over to the IAAI and help us add some of those features to
the test suite.  Personally, I think that stuff is overkill because in a
real production environment you don't have those issues, and it will
skew the results towards techniques that don't take advantage of the
inherent cache mechanisms of OS/400.


In any event, the test suite is almost ready for public discourse.  I
will try to make the first version available this weekend.  It's not
intended to be commercial grade; it certainly won't worry about all of
your concerns, Vern.  But it will run tests and it will provide a simple
framework for adding more tests.  The only question is how much
documentation I'll have in place.  But those of you who are have strong
opinions about how benchmarks should be run, please come on over and add
your suggestions.


Joe
http://forums.plutabrothers.com/IAAI