Recalculate database statistics ‌

We recommend that you recalculate database statistics regularly. Depending on the size of your database, this operation may take a few hours. When successfully completed, it speeds up queries and increases system performance.

To compute statistics, connect to the Dimensions CM database manager, DMDBA, as the system user and run this command:

dmdba system/sys_password@<dsn name> 
connect base_db
statistics compute

For more information about DMDBA, see the Administration Guide.