RDBPROD: TRUNCATE TABLE or DROP INDEX May Leave Wasted Space
Last updated on AUGUST 09, 2016
Applies to:Oracle Rdb Server on OpenVMS - Version 184.108.40.206 to 220.127.116.11 [Release 7.2]
HP OpenVMS Itanium
HP OpenVMS Alpha
When performing a TRUNCATE TABLE or a DROP INDEX on a HASHED INDEX stored in mixed-format area, not all buckets for records are effectively removed.
This may lead to wasted space on a page. New INSERTs may not find enough space on a page and overflow records need to be created, which may lead to declining performance.
This problem occurs only under Rdb 18.104.22.168, on both Alpha and Itanium
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