What is use of "Studio >> Manager >> Request Panel >> 'cache' column" in TDV?

This article will explain the use of "Studio >> Manager >> Request Panel >> 'cache' column"

The "Cache" column in the Requests panel tells whether the query engine was able to use a query plan that had been cached.  Query plans are cached in memory for optimization reasons. Plans are removed from the cache when there has been a change in the view, the plan cache had become full and the query engine had to remove the plan, the plan in the cache has timed out, etc.

When a resource is published and called by different clients (JDBC, ODBC, etc.), the cached plan is most likely removed and regenerated because there has been a change.

Note: This has nothing to do with a data cache. Using the DISABLE_PLAN_CACHE option in a view will cause the query engine to regenerate the plan every time the view is executed. Hitting the "Clear Plan Caches" button on the Requests panel will clear out all cached plans from memory. Otherwise, it is up to the query engine to determine when to remove cached plans.