SICSR-17455

[SICSR-17455] BOAC_PC_FACT additional index
Product Line:	P&C
Component/s:	Reporting - Business
Affects Version/s:	SICS 4.9.3
Fix Version/s:	SICS 20.1
Customer:	Labuan Re

Problem:
Performance problems in accounting reports due to missing index

Solution:

Add this index to the BOAC PC FACT table

CREATE INDEX [IX_BOAC_PC_FACT_IS_ESTIMATE_IS_IN_ACCT_CURR]

ON [BOAC_PC_FACT] ([IS_ESTIMATE], [IS_IN_ACCT_CURR], [FK_CLAIM_TO_SOC], [FK_BALANCE], [OBJECT_ID], [NO_TRANSFER_LDGR])

Workaround:
Apply the index manually

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected