STEP 1: Create tuning task for the specific SQL_ID: STEP 2: Check the status of newly created task: STEP 3: Execute the newly created task: STEP 4: Check the status after executing the task: STEP 5: Execute the Below Query to get the Advisory Report: report says that by creating index we will get 99% … Continue reading Run sql tunning advisor for sql_id