COMPUTE_SOURCE_TABLE_STATS¶

Description

The stored procedure COMPUTE_SOURCE_TABLE_STATS takes a base view specified as an input parameter and executes the necessary commands on the underlying data source so this one computes the statistics of the table referenced by that base view. Notice this operation only computes the statistics on the data source. In order to gather these statistics in VDP you need to follow the instructions in section Gathering the Statistics of Views of the Virtual DataPort Administration Guide.

Syntax

COMPUTE_SOURCE_TABLE_STATS (
      database_name : varchar
    , base_view_name : varchar
)

Note

Currently, this feature is only supported for the Denodo Embedded MPP data source and PrestoDB data sources.

The procedure returns this field:

procedure_status: Success if the procedure executed correctly, Failure otherwise.

Privileges Required

The user that executes this procedure must have at least WRITE and EXECUTE privileges on the targeted view and EXECUTE on the data source.

Example

CALL COMPUTE_SOURCE_TABLE_STATS('db', 'test_view');

This will compute the statistics on the source table pointed by test_view. The statistics can be updated from the statistics tab in the base view dialog.

USER MANUALS

COMPUTE_SOURCE_TABLE_STATS¶