Re: Object Oriented Wrapper classes to SQL statements

Clifford,

The syntax you made up resembles, to a surprising degree, the syntax you get from RDMS$DEBUG_FLAGS "S" from the old DEC Rdb (now Oracle Rdb). Or maybe I shouldn't be surprised.

That output is after the optimizer has done reworking the plan, and decided on the cheapest path. That, in turn can be used to tune the query, or to provide hints.

BTW, Rdb had (still has) a really great optimizer. I got spoiled by it. Fortunately the "Oracle Oracle" optimizer is now catching up.

--
Regards,
    David Cressey
    www.dcressey.com