RDBPROD: Poor Query Performance After RMU/LOAD Until RMU/COLLECT Performed

(Doc ID 1395818.1)

Last updated on MARCH 02, 2018

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.2 and later
HP OpenVMS Itanium
HP OpenVMS Alpha


A database was rebuilt from scripts, tables loaded using RMU/LOAD, and indexes recreated. During testing it was noted that the performance of a join query on two tables was poor. RMU/COLLECT was performed and query performance was restored to expected good performance. Why was RMU/COLLECT required?




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms