Open for Voting

More information for query tuning, like the existing indexes on tables involved in the query.

When trying to tune a sql statement it would be useful to add more information.  Using a better explain plan with dbms_xplan has already been suggested and I think that is a must, however, other things can also be added.

1) a ranking of how important the query is, # of exec by this query to other queries in the interval

2) ranking could be done in terms of executions, IO requests, buffer gets, etc

3) to tune the query it would be useful to have the indexes defined on the table along with the columns

4) see the stats information for the table and columns,  ie. last_analyzed date number of rows in the table, along with the number of distinct value counts for the predicates which could be helpful in deciding if new indexes are required.

Scott.