The Recommendations for SQL ID:5mxdwvuf9j3vp page is shown.
The Return button is on the right side of the page.
The SQL Text is SELECT /* ...
The Select Recommendation section includes the Original Explain Plan (Annotated) button. Underneath it is the Implement button.
The table includes the following columns: Select, Type, Findings, Recommendations, Rationale, Benefit (%), New Explain Plan, Compare Explain Plans.
Row 1 has the following values: (selected), SQL Profile, "A potentially better execution plan was found for this statement", "Consider accepting the recommended SQL profile", null, 99.56, (spectacles icon), (spectacles icon).
Row 2 has the following values: (deselected), Index, "The execution plan of this statement can be improved by creating one or more indices", "Consider running the Access Advisor to improve the physical schema design or creating the recommended index", "Creating the recommended indices significantly improves the execution plan of this statement. However, it might be preferable to run 'Access Advisor' using a representative SQL workload as opposed to a single statement. This will allow to get comprehensive index recommendations which takes into account index maintenance overhead and additional space consumption", 62.08, (spectacles icon), (spectacles icon).
End of description.