Refreshing All Execution Plan Caches
TDV Server caches view-query execution plans. If the view SQL uses data sources with fresh cardinality statistics, you might want to purge and refresh the query plan cache by temporarily changing the Query Plan Cache configuration setting, which forces a one-time regeneration of all execution plans.
To purge all query execution plans
1. Select the Administration > Configuration menu option.
2. In the Configuration window, select TDV Server > SQL Engine > Caches > Query Plan Cache Enabled.
3. In the right pane, select the False radio button and click Apply.
4. Select the True radio button, click Apply, and click OK.
Or
Refresh a query plan cache by making a minor change to the View SQL or procedure. This forces creation of a new query execution plan.
5. Save the change.
The next execution uses any cardinality statistics available to optimize query plan execution.