Index mismatch when partitioning WF tables in 12.24 with wfpart.sql
Hi,
I plan to partition Workflow tables on my 12.2.4 instance.
Scripts version are the following:
wfpart.sql:Rem $Header: wfpart.sql 120.4.12020000.2 2012/07/19 22:01:13 alsosa ship $
wfpartb.pls:/* $Header: wfpartb.pls 120.7 2009/03/02 14:45:18 alsosa ship $ */
wfparts.pls:/* $Header: wfparts.pls 120.4 2006/03/26 22:07:55 rtodi noship $ */
I've generated the wfpart.sql script but there is some differences between indexes on partitioned tables and indexes on the original tables. For some of them i've found bugs and MOS notes to correct it but for the others i dunno if it's bug or if it's an index update because of the partitioning key. here is all the differences i got:
WF_ITEM_ACTIVITY_STATUSES