« PL/SQL developer compile error workaround | Main | New Job Submission: SZRSTRK »
November 29, 2007
Compiler hints and the database merge
The old compiler hint ( /*+ ALL_rows */ ) we added to our programs, packages, and views to speed things up seem to be slowing things down. I've been removing the ones that have been coming up as a problems so far. The other hints ( /*+ RULE */, /*+ driving_site(spriden) */ ) haven't been a problem so far. Eventually we'll want to remove them all from our programs. Some packages we'll be able to go back to baseline once we remove these.
Posted by soukupm at November 29, 2007 4:38 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)