Prev
Next
Forums S3 Systems Administration

how to disable Oracle hintsfor a batch

Sort:
You are not authorized to post a reply.
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
    You are not authorized to post a reply.