I am working on a piece of code which analyzes the execution plan of
DB2 SQL statements.
In order to test it, I need a set of statements (and the definitions
of the objects to which the statements refer)which cover as many
execution plan options as possible (different operator types,
different options, diverse predicates, etc.).
I am sure I am not the first one to encounter such a problem. It would
be great if you could direct me to such a "statements database" if you
know one.
Thanks,
Ilan
--CELKO-- - 07 May 2008 21:07 GMT
DeWitt had a test database anf the TPC databases are out there. Might
be a place to start.