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
- Run the Clean PA collections job (PACollectionCleaner).
- 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:
Related Problem: PRB702680