Return
-
Title
Reader is slow on a horizontal partitioned table -
Description
Read is slow on horizontal partitioned table for updates and deletes
-
Cause
Reader needs to query database for partitioned column
-
Resolution
Add supplemental logging group for the horizontal partitioned column. Here is an example:
ALTER TABLE owner.table_name ADD SUPPLEMENTAL LOG GROUP GROUP_NAME (Key col1, column in HP col2..) ALWAYS;
If this is created then reader has the key values available and does not have to query the database for values.