Showing posts with label SQL Tuning Advisor. Show all posts
Showing posts with label SQL Tuning Advisor. Show all posts
Friday 23 February 2018
How to use SQL Tuning Advisor in Oracle SQL Developer?
Oracle SQL Developer -> Connections -> Right mouse click on desired database connection name (e.g. XE) -> Click "Open SQL Worksheet" -> Input and select SQL code block -> Right mouse click then select "SQL Tuning Advisor" or press "CTRL+F12" -> Lastly, analyze the result.
Subscribe to:
Posts (Atom)