Latest Activity

Result of LIST VIEWSTATSUMMARIES in GET_STATS_FOR_FIELD

Hi there I want to refresh the statistics (at the end via scheduler) for those views which have the stats enabled. The refresh can be done with the new GETSTATSFORFIELD like call GETSTATSFORFIELDS ( 'ATSOURCETHROUGHVDPONLY' ,'myDB' , 'myView' ,null, t...

Statistics

View statistics questions

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...

generate_stats search methods VDP resultset Statistics timeout

List all interfaces with field names

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...

names Interface statistics

How to get list of views with statistics enabled

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

views with statistics view properties properties statistics

statistics on derived views vs base views

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

statistics

Error while trying to gather stats

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...

Statistics