The stored procedure
GENERATE_SMART_STATS_FOR_FIELDS_BY_TABLENAME behaves as the
procedure GENERATE_SMART_STATS_FOR_FIELDS with the difference that
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
customer_final but you want to obtain the statistics from the
This is the only difference between this procedure and
mode : text
, view_name : text
, fields : array
, table_stats : boolean
, source_table_name : text
, source_schema_name : text
, source_catalog_name : text
, database_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
nullif the database does not have schemas.
source_catalog_name: catalog of the table from which you want to gather the statistics. Enter
nullif the database does not have catalogs.
The other input parameters have the same meaning that in GENERATE_SMART_STATS_FOR_FIELDS.