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.
COMPUTE_SOURCE_TABLE_STATS ( database_name : varchar , base_view_name : varchar )
Currently, this feature is only supported by PrestoDB data sources.
The procedure returns this field:
Successif the procedure executed correctly,
The user that executes this procedure must have at least
EXECUTE privileges on the targeted view and
EXECUTE on the data source.
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.