Using Update Statistics

Set this option to update the statistics of an index after every creation (compiled in DWD or created in SQL).

Select this option to set the Auto-Update Statistics in SQL (database option) to false for both Staging and Catalog databases. If clear, this reverses the settings for the databases.

DWD Designer checks if Auto-Update Statistics is enabled for Staging or Catalog databases in SQL. If Update Statistics is also selected, this prompts the user with a warning.

Note: 

We recommend that you enable DWD Update Statistics or use SQL Auto-Update Statistics for Staging and Catalog databases. Otherwise DWD performance may be degraded.

To maximize this feature, when using Update Statistics, we recommend enabling "Remove indexes before ETL and then recreate them" in Transformation option. Setting ETL Processing Options

To enable update statistics:

  1. From the main menu, select Compile > Compilation Options.
  2. Select Update Statistics.
  3. Click OK.