The archive tables like H_GENERIC_JOB and H_APPLICATION can grow overtime. If you have implemented MOVEHISTORYDATA in housekeeping, it will move the data from historical tables like ESP_GENERIC_JOB and ESP_APPLICATION to corresponding archive tables.
If the row count in H_ tables is in several millions (over 10-20 million), then you may need to add indexes to the archive tables. Here is an example of adding to H_GENERIC_JOB for START_DATE_TIIME field.
CREATE INDEX DESCHEMA.IDX_H_GNRC_START_DATE ON DESCHEMA.H_GENERIC_JOB
ALTER INDEX DESCHEMA.IDX_H_GNRC_START_DATE LOGGING NOPARALLEL;
CREATE NONCLUSTERED INDEX IX_H_GNRC_START_DATE ON DEUSER.H_GENERIC_JOB (START_DATE_TIME);
CREATE INDEX CONCURRENTLY idx_h_gnrc_start_date ON H_GENERIC_JOB (START_DATE_TIME);
Note: The above SQL commands are examples and for reference only. It is recommended to contact your DBA for more information on how to create the indexes. CA recommends to take full backup of database before making any changes to it. DE must also be shutdown to prevent any failures.