Joined: 11 Aug 2009
|Does anyone has experience with this ?
I don't have the budget for Apptune or plan analyzer. Besides they do a lot more than I need.
We do have explain info .
We do have several versions of packages,
We don't code Queryno in our cobol (yet).
I would compare explains from 1 program.
- in different subsystems
- different versions
- same version after rebind
And compare estimated costs , order of tables,...
Has anyone tried this before or is doing this and would like to share some experiences on how to handle all this, pitfalls to avoid ?