Manually update database statistics

Database statistics are used to ensure that your database is providing data to Accounting CS as efficiently as possible. Typically these statistics are automatically updated as needed. Manually updating the statistics can be useful if response times are slower than usual or if a significant number of changes have been made to the data at once.
  1. Select
    Help
    , then
    Update Statistics
    .
  2. If the process fails, contact your database administrator to verify the following configurations:
    1. The
      Server authentication mode
      is set to
      SQL Server and Windows Authentication mode
      for your SQL Server instance.
    2. The database owner login
      CreativeSolutionsPracticeCsDatabaseOwner
      exists.
    3. The database owner login
      CreativeSolutionsPracticeCsDatabaseOwner
      has the proper permissions.
    4. There is sufficient RAM available on both the workstation and the server.
  3. After verifying these items, select
    Help
    , then
    Update Statistics
      to manually update the statistics in the database.