Read is slow on horizontal partitioned table for updates and deletes
Reader needs to query database for partitioned column
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;
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy