Q&A BY TAG 'statistics'

You must sign in to ask a question. If you do not have an account, you can register here

View statistics questions
answered 06-02-2020 00:08:36 -0500

I recently inherited Denodo admin duties and am investigating a scheduled job which is failing. The job gathers a list of all base tables in Denodo, then runs the following VQL: CALL GENERATE_SMART_STATS_FOR_FIELDS('SMART_THEN_ATSOURCE_THROUGH_VDP','B...

Answers: 5

generate_stats search methods VDP resultset Statistics timeout

List all interfaces with field names
answered 09-12-2019 12:12:35 -0500

We're looking to get a list of all our interfaces, with field names, and preferably attributes (ex. data type, max length). The end goal is to allow report developers to be able to search for all interfaces which contain specific field names. Is this p...

Answers: 2

names Interface statistics

How to get list of views with statistics enabled
answered 13-06-2019 20:19:58 -0400

How can I get a list of views where statistics has been enabled for a given database?

Answers: 1

views with statistics view properties properties statistics

statistics on derived views vs base views
answered 05-06-2018 08:56:40 -0400

when calculating the statistics of a view is it better to do that on a derived view or do I also need to do it on the base views that make the derived view

Answers: 1


Error while trying to gather stats
answered 21-03-2017 11:42:39 -0400

I keep getting error, on any jdbc while trying to gather stats manually. I am getting the error : Error executing query. total time ... Query [VIRTUAL] [ERROR] when looking into the logs, I get : com.denodo.vdb.engine.storedprocedure.jdbc.QueryResultS...

Answers: 2