RDBPROD: Poor Performance for Delete from a Table
Last updated on AUGUST 03, 2016
Applies to:Oracle Rdb Server on OpenVMS - Version 7.1 and later
HP OpenVMS Alpha
HP OpenVMS Itanium
A delete of a record in a specific table is taking a very long time. Inserts and updates occur very quickly. SELECT on the rows that fit the criteria for the DELETE also return the results very quickly.
The table in question does have SORTED indexes, some of which have DUPLICATES ALLOWED.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms