When tuning a query, you need some basic info. However, if the query is complex and the views used are comples it is time consuming to find all underlying tables, then run help stats on each..look at joins etc.
Is there a script which will-
1. The script will get description of the view, no of row views will pull up.
2. This script runs show table, help stats, select count and an amp usage for a table, what indexes are available, are stats current, how many unique values are there, how many rows in the table, is the table well ditributed, or is there a hot-amp. etc.