You can translate the question and the replies:

Cached view using statistics in the query execution

Hi, we are using denodo 6 with cache db as Oracle. we want to explore collecting statistics for the cached views brought in from the other data sources. Is there a way to check if we execute a query on the cached view that those statistics are being utlized. This is to determine if there would be any benefit in terms of performance when using them and any trade off we would have in terms of storing and maintaining those statistics. Thanks.
user
01-02-2019 18:16:35 -0500

1 Answer

Hi, You can see if the cost-based optimizer has been used in the generation of a query plan by looking at the query's execution trace. When it is used, a "Cost Optimization" header appears under the execution node. For more information, check this out: https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/querying_views/execution_trace_of_a_statement When working with cached views, it is important to know that the statistics are generated using the original data source itself, not the cached version. Keep that in mind if the cache mode is different from full. Hope this helps!
Denodo Team
06-02-2019 05:50:23 -0500
You must sign in to add an answer. If you do not have an account, you can register here