Does Teradata make use of "Query Caching" for the fast retrieval of tactical query results? If so, which tables in the data dictionary are used for this purpose? What are the pros and cons of making use of this concept in data warehouse?
Right, it means that query plan is generated at run time and optimizer chooses the best plan. Definitely the STATISTICS should have their part in this regard.
And yes, you are right that due to diversity of query & results, it'd not be a good techneque to store queries alongwith the associated results, as it will be an additional cost. Recently, I studied such techneque, that's why I wanted to confirm.