As the system is running, index records are frequently created for the workflow runtime tables and then deleted again. This has a negative effect on the performance if you access the system using these indexes as a result the performance of the workflow system in an operational system becomes increasingly slow, even though the overall load remains the same.
To improve the performance of the workflow system depending on the data volume of the processes, indexes of the database runtime tables should be reorganized regularly (for example, on a monthly basis). If you use ORACLE or INFORMIX, you can use the SAP tool SAPDBA to do this. After an archiving run, you should always start the reorganization. For this purpose, edit the indexes of the following tables:
Release 4.6C and lower:
SWW_CONT
SWW_CONTOB
SWWWIDH
SWWORGTASK
SWWWIAGENT
SWWWIHEAD
SWWWIDEADL
SWWEI
SWWWIRET
SWEINSTCOU
SWWLOGHIST
SWWLOGPARA
SWZAI (if worklists are used)
SWZAIENTRY (if worklists are used)
SWZAIRET (if worklists are used)
SWPNODELOG
SWPSTEPLOG
SWP_ADM_US
SWP_HEADER
SWWBINDEF
SWWRUNMETH
SWWSWPRET
SWP_NODEWI
Release 620
SWW_CONT
SWW_CONTOB
SWWCNTP0
SWWCNTPADD
SWWWIDH
SWWORGTASK
SWWWIAGENT
SWWWIHEAD
SWWWIDEADL
SWWEI
SWWWIRET
SWEINSTCOU
SWWLOGHIST
SWZAI (if worklists are used)
SWZAIENTRY (if worklists are used)
SWZAIRET (if worklists are used)
SWPNODELOG
SWPSTEPLOG
SWP_ADM_US
SWP_HEADER
SWP_NODEWI
SWW_WI2OBJ
Releases 640, 700, 710
SWW_CONT
SWW_CONTOB
SWWCNTP0
SWWCNTPADD
SWWWIDH
SWWORGTASK
SWWWIAGENT
SWWWIHEAD
SWWWIDEADL
SWWEI
SWWWIRET
SWEINSTCOU
SWWLOGHIST
SWZAI (if worklists are used)
SWZAIENTRY (if worklists are used)
SWZAIRET (if worklists are used)
SWPNODELOG
SWPSTEPLOG
SWP_ADM_US
SWP_HEADER
SWP_NODEWI
SWPNODE
SWW_WI2OBJ
SWW_EVENTCRL
SWW_EVENTS
SWW_WIREGISTER