Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

how to disable Oracle hintsfor a batch

 0 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
DQ Phan
Basic Member
Posts: 19
Basic Member
7/14/2009 1:32 PM
    Hi all,
    We'd like to test some Oracle DB Partitioning.
    To give Oracle full power to choose the best access path from it's optimizer, after the implementation of db partitioning, we want to disable the default Oracle hint in a batch.
    Is there a way to do that, instead of specify all indexes that the batch may used in a .cfg file ?

    TIA