« Updated SGRSPRT for Athletic Aid Indicator for 2007-08 | Main | New Job Submission: SZRICMP »
January 31, 2008
Removed all_rows compiler hint from applications
I removed all the spriden /*+ all_rows */ compiler hint from our applications yesterday (Pro C, Perl, SQL, PL/SQL). These are no longer needed because of the database consolidation since spriden is no longer a view on SIS. All of the applications I modified are listed in the file I:\Staff\Programmers\Banner_Stuff\consolidation\all_rows_hint.txt just in case we need to put the hint back on. All of the programs I tested seemed to work well and some ran faster with the hint removed.
Posted by soukupm at January 31, 2008 11:12 AM
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.)