The standard behavior of the platform TableCleaner is to count all records of a table. In cases of pa_scores and pa_snapshots, the table can contain a large number of rows and therefore the count query can take several minutes.

Steps to Reproduce

  1. Run the Clean PA collections job (PACollectionCleaner).
  2. Monitor the database to find a query like SELECT count(*) AS recordcount FROM pa_scores pa_scores0.


Customers on Geneva or Helsinki can add the table dictionary attribute "no_optimize" and set it's value to true to prevent the expensive query on the following tables:

  • pa_scores
  • pa_snapshots

Related Problem: PRB702680

Seen In

Geneva Patch 6 Hot Fix 2

Fixed In

Helsinki Patch 10

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2017-11-07 08:44:38