GENERATE_SMART_STATS_FOR_FIELDS_BY_TABLENAME

Description

The stored procedure GENERATE_SMART_STATS_FOR_FIELDS_BY_TABLENAME behaves as the procedure GENERATE_SMART_STATS_FOR_FIELDS with the difference that with GENERATE_SMART_STATS_FOR_FIELDS_BY_TABLENAME you can gather the statistics of a base view from a table/view of the database that is not the one that is linked to the base view. Use this procedure to gather the statistics of a base view whose table in the database is called customer_final but you want to obtain the statistics from the table customer.

This is the only difference between this procedure and GENERATE_SMART_STATS_FOR_FIELDS.

Syntax

GENERATE_SMART_STATS_FOR_FIELDS_BY_TABLENAME (
      mode : text
    , view_name : text
    , fields : array
    , table_stats : boolean
    , source_table_name : text
    , source_schema_name : text
    , source_catalog_name : text
)
  • source_table_name: name of the table from which you want to gather the statistics.
  • source_schema_name: schema of the table from which you want to gather the statistics. Enter NULL if the database does not have schemas.
  • source_catalog_name: catalog of the table from which you want to gather the statistics. Enter NULL if the database does not have catalogs.