To capture an SQL statement from a trigger, SQL user-defined function, or view:
Now that the workflow assistant for query tuning has the SQL statement, you can use the features on the Run All Single-Query Advisors and Analysis Tools page to generate analyses of and recommendations for tuning the statement.