From DB Optimizer
Jump to: navigation, search

Tune - Apply

What does "apply" do on generated cases right click menu?

I tried the following use cases in Oracle 10g, the findings for each follow:

1. Ad Hoc
//Hint is inserted into ad hoc query in overview page (no changes to files or database).
2. SQL File
//Hint is inserted into filename.sql and saved.
3. Stored Procedure
//Stored Procedure is updated with new hint and the updated procedure is saved in the database.