Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Turning hints off globally

 0 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
slavo
Basic Member
Posts: 8
Basic Member
3/2/2012 9:02 PM
    We found that if we turn hints off most batch jobs run much faster (30% to 60%). However this can only be done at a global level; meaning the parameter is in the ORACLE file and not in a program config file. The parameters is "USEHINTS=FALS".  Our DBA says that this is safe to do because Oracle is better at determining what access path is best to retrieve data for Lawson that Lawson hints. Has anyone done this and if so, what if any are reprecusions?