How to interpret results of "Automatic SQL Tuning Result Details: SQLs with Findings"
Hi there
I am looking arround at the Automatic SQL Tuning results page in OEM 12.1.0.4.0 and have question about how to interpret the info displayed. The statements in the view are there statement of which OEM "thinks" they could be better and faster (?) when using the proposed profile or index?
My page looks like (there are missing some irrelevant columns), these are the first 3 rows of many....(order by Weekly DB time benefit, descending)
4703,872657,80scott1200,31
17-3-2017 22:20:12
| SQL Text | parsing schema | SQL ID | Weekly DB time benefit | Profile | Index | Date |
|---|---|---|---|---|---|---|
SELECT * FROM <table> WHERE...... | scott | 6gxy0udnd68 | 4705,21 | 99% | 15-3-2017 22:23:00 | |
| SELECT JBT.* FROM < table> WHERE..... |
0