From DB Optimizer
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.