Is it possible to write adjust cost routine as a SQL query?
Adjust cost routine takes about 2 to 2.5 hours to run. We run it nightly at 1 AM. It causes tons of locks/blocks. The client that I work for, runs 24X7.
I was wondering, if is it possible to convert the adjust cost report to a SQL query. Has anyone been able to do that?