The Recommendations for SQL ID:05b6pvb81dg8b section is shown.
The Return button is to the right of the page.
The SQL Text section shows the following text:
SELECT /*+ ORDERED USE NL(c) FULL(c) */ COUNT(*) FROM SH.SALES S, SH.CUSTOMERS C WHERE C.CUST_ID=S.CUST_ID AND CUST FIRST NAME='Dina' ORDER BY TIME
The Selection Recommendation section includes the Original Explain Plan (Annotated) button.
The Implement button is shown.
The table includes the following columns: Select, Type, Findings, Recommendations, Rationale, Benefit (%), New Explain Plan, Compare Explain Plans.
Row 1 includes the following values: (selected), SQL Profile, "A potentially better execution plan was found for this statement", "Consider accepting the recommended SQL Profile.", null, 99.63, (spectacles icon), (spectacles icon).
End of description.