The screenshot shows the Actions and SQL Affected by Recommendations sections of the Recommendation Details page. At the top of the Actions section is the "Set Tablespace for All Actions" text entry field, which is blank. Next to the text entry field is a search icon (a flashlight symbol), and to the left of that is a button labeled Go. Below the text entry field is a table. There are 6 columns and 4 rows in the table. The column headings are, from left to right: Implementation Status, Recommendation Ids, Action, Object Name, Object Attributes, and Base Table. The rows in the table have the following values:
A blue square, 3, CREATE MATERIALIZED VIEW LOG (hyperlinked), no value, no value, SH.CUSTOMERS
A blue square, 3, CREATE MATERIALIZED VIEW LOG (hyperlinked), no value, no value, SH.SALES
A blue square, 3, CREATE MATERIALIZED VIEW (hyperlinked), MV$$_0065002 (modifiable), General Match, no value
A blue square, 3, GATHER TABLE STATISTICS (hyperlinked), MV$$_0065002, no value, no value
The SQL Affected by Recommendations section contains a table with 8 columns and 1 row. The column headers and row values are, from left to right:
Statement ID: 2283 (hyperlinked)
Statement: SELECT c.cust_id, SUM(amount_sold) AS dollar_sales FROM sales s, customers c WHERE s.cust_id = c.cust_id GROUP BY c.cust_id
Recommendation ID: 3
Original Cost: 8
New Cost: 6
Cost Improvement: 2
Cost Improvement (%): 25.00
Execution Count: 2
End of description.