The cost based optimization settings will enable you to manipulate base SQL queries based on optimization statistics.
Caution: Do not alter these settings unless you are familiar with cost based optimization. Contact My Oracle Support for more information.
To set your cost based optimization settings:
- Open the Primavera P6 Administrator.
- In the Configurations drop-down list, select your configuration.
- In the sidebar select Database/Instance[n]/Cost Based Optimization settings.
Note: Changes to these settings require you to restart the P6 server.
- Select Enable, to enable Cost Based Optimization. Leave the field clear to disable it.
- Select Dump Matching SQL, select to dump the SQL where a match is found in the QUERYLIB table for a given SQL statement.
Leaving the field clear to dump the SQL where a match is not found in the QUERYLIB table for a given SQL statement.
Note: To see these entries, you must set your logging level to INFO in Configuring Log Settings.