Current after upgrade, version 1.30 → 1.31, steps:
Execute stored procedure
call <app_name>.core.deploy_source_tasks( ).
This deploys necessary tasks in each source schema to enable support for delta-size-based merge on already created source schemas. New source schemas will have delta-size-based merge support enabled by default.
Execute stored procedure
call <app_name>.core.deploy_merge( ).
Deploy merge stored procedure must be executed with storage settings as they were after the upgrade to mitigate the risk of side effects.
Before executing call <app_name>.core.deploy_merge( ) you can execute it on a subset of tables to check for side effects:
call <app_name>.core.deploy_merge('<DB>') -- Only in one Databasecall <app_name>.core.deploy_merge('<DB>','<SCHEMA>') -- Only in one schemacall <app_name>.core.deploy_merge('<DB>','<SCHEMA>','<TABLE>') -- Only for one table
This re-deploys tasks and views for all tables. This enables support for statistics capture. New tables will have statistics capture support enabled by default.