SEO

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

DeWitt had a test database anf the TPC databases are out there. Might
be a place to start.