Description of the illustration sql_access_results_rec.gif

The screenshot shows the Recommendations subpage of the Results for Tasks page. There are two sections on the subpage: Recommendations by Cost Improvement and Select Recommendations for Implementation.

The Recommendations by Cost Improvement section contains a bar chart. The vertical axis measures the Cost Improvement, with values from 0 to 12,000 incrementing by 2,000. The horizontal axis shows the ID, with values, from left to right, of 1, 2, 3, and 4. The legend shows that blue bars measure Cost Improvement. All the bars in the graph are blue.

For ID 1, the cost improvement is 10,000.
For ID 2, the cost improvement is 10,000.
For ID 3, the cost improvement is 6,0000.
For ID, the cost improvement is 0.

The Select Recommendations for Implementation section contains a table. Just below the section heading is the Include Retain Actions option, which is selected. Below this option are the Recommendation Details, Schedule Implementation, and Show SQL buttons. Below the Recommendation Details button are two links, Select All and Select None.

The columns of the table are: Select, Implementation Status, ID, Actions, Action Types, Cost Improvement, Cost Improvement (%), Estimated Space Used (MB), and Affected SQL Statements. The values of the Select column are check boxes. The values in the Implementation Status column are icons. The values in the ID column are links. The values in the Action Types column are colored squares. A legend below the table identifies the following action types: Indexes, Materialized Views, Materialized View Logs, Partitions, and Others. The rows in the table have the following values:

Row 1: (selected), (pending), 1, 1, Indexes, 9892, 38.36, 0.150, 1.
Row 2: (selected), (pending), 2, 1, Indexes, 9760, 37.85, 3.365, 1.
Row 3: (selected), (pending), 3, 4, Materialized Views, Materialized View Logs, and Others, 6132, 23.78, 0.008, 1
Row 4: (not selected), (completed), 4, 1, Indexes, 0, 0.00, 0.000, 1

End of description.