Profiling and Discovery Sizing Guidelines

Back Next

Database Statistics

Update the database statistics to allow the database to quickly run the queries on the profiling warehouse.

IBM DB2: To update the statistics, run the following command:

RUNSTATS ON TABLE <TABLE NAME> WITH DISTRIBUTION AND DETAILED INDEXES ALL
Oracle: By default, Oracle gathers database statistics and therefore, you do not need to perform any action. For more information, refer the documentation on Oracle
DBMS_STATS
command.
Microsoft SQL Server: By default, Microsoft SQL Server gathers statistics and therefore, no action is required. To update the statistics more frequently than the default recommended option, refer the documentation on SQL Server UPDATE STATISTICS command.