Adding Indexes to Improve Performance of S_ORG_EXT Table

The S_ORG_EXT table has indexes on many columns, but not all columns. If you have a large number of records (such as several million accounts) in S_ORG_EXT, then you might get a performance improvement in deleting and merging by adding an index to one or more of the following columns:

PR_BL_OU_ID
PR_PAY_OU_ID
PR_PRTNR_TYPE_ID
PR_SHIP_OU_ID

You can make subqueries to base tables that access only indexes. Performance is enhanced because all related records are physically collocated, and because index leaf pages contain many more records per page than wider base table pages. Before implementing any additional indexes, first discuss this with qualified support personnel.