Can the Seeded Unused Indexes That Come With OFSAA Installation Be Dropped?

(Doc ID 2380825.1)

Last updated on APRIL 03, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.3.3.0 and later
Oracle Financial Services Profitability Management - Version 6.1 and later
Oracle Financial Services Asset Liability Management - Version 6.1 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)

Goal

Can the unused indexes that come pre-installed with OFSAA be dropped?   For example, some indexes that come with OFSAA when first installed:

INDEX_NAME	TABLE_NAME	MONITORING	USED
PK_PR2_RULE_QUERY	PR2_RULE_QUERY	YES	NO
IDX_FSI_D_ANNUITY_CONTRACTS_9	FSI_D_ANNUITY_CONTRACTS	YES	NO
IDX_FSI_D_ANNUITY_CONTRACTS_8	FSI_D_ANNUITY_CONTRACTS	YES	NO
IDX_FSI_D_ANNUITY_CONTRACTS_7	FSI_D_ANNUITY_CONTRACTS	YES	NO
IDX_FSI_D_ANNUITY_CONTRACTS_6	FSI_D_ANNUITY_CONTRACTS	YES	NO
IDX_FSI_D_ANNUITY_CONTRACTS_5	FSI_D_ANNUITY_CONTRACTS	YES	NO
IDX_FSI_D_ANNUITY_CONTRACTS_4	FSI_D_ANNUITY_CONTRACTS	YES	NO
IDX_FSI_D_ANNUITY_CONTRACTS_3	FSI_D_ANNUITY_CONTRACTS	YES	NO
IDX_FSI_D_ANNUITY_CONTRACTS_2	FSI_D_ANNUITY_CONTRACTS	YES	NO
FSI_D_ANNUITY_CONTRACTS	FSI_D_ANNUITY_CONTRACTS	YES	NO
FSI_D_LEASES	FSI_D_LEASES	YES	YES
IDX_FSI_D_LEASES_9	FSI_D_LEASES	YES	NO
IDX_FSI_D_LEASES_8	FSI_D_LEASES	YES	YES
IDX_FSI_D_LEASES_7	FSI_D_LEASES	YES	NO
IDX_FSI_D_LEASES_6	FSI_D_LEASES	YES	YES
IDX_FSI_D_LEASES_5	FSI_D_LEASES	YES	YES
IDX_FSI_D_LEASES_4	FSI_D_LEASES	YES	YES
IDX_FSI_D_LEASES_3	FSI_D_LEASES	YES	YES
IDX_FSI_D_LEASES_2	FSI_D_LEASES	YES	NO
IDX_FSI_D_LEASES_10	FSI_D_LEASES	YES	YES
FSI_D_LEDGER_STAT_INSTRUMENT	FSI_D_LEDGER_STAT_INSTRUMENT	YES	NO
IDX_FSI_D_LEDGER_STAT_INSTRU_9	FSI_D_LEDGER_STAT_INSTRUMENT	YES	NO
IDX_FSI_D_LEDGER_STAT_INSTRU_8	FSI_D_LEDGER_STAT_INSTRUMENT	YES	NO
IDX_FSI_D_LEDGER_STAT_INSTRU_7	FSI_D_LEDGER_STAT_INSTRUMENT	YES	NO
IDX_FSI_D_LEDGER_STAT_INSTRU_6	FSI_D_LEDGER_STAT_INSTRUMENT	YES	NO
IDX_FSI_D_LEDGER_STAT_INSTRU_5	FSI_D_LEDGER_STAT_INSTRUMENT	YES	NO
IDX_FSI_D_LEDGER_STAT_INSTRU_4	FSI_D_LEDGER_STAT_INSTRUMENT	YES	NO
IDX_FSI_D_LEDGER_STAT_INSTRU_3	FSI_D_LEDGER_STAT_INSTRUMENT	YES	NO
IDX_FSI_D_LEDGER_STAT_INSTRU_2	FSI_D_LEDGER_STAT_INSTRUMENT	YES	NO
FSI_D_LOAN_COMMITMENTS	FSI_D_LOAN_COMMITMENTS	YES	NO
IDX_FSI_D_LOAN_COMMITMENTS_9	FSI_D_LOAN_COMMITMENTS	YES	NO
IDX_FSI_D_LOAN_COMMITMENTS_8	FSI_D_LOAN_COMMITMENTS	YES	NO
IDX_FSI_D_LOAN_COMMITMENTS_7	FSI_D_LOAN_COMMITMENTS	YES	NO
IDX_FSI_D_LOAN_COMMITMENTS_6	FSI_D_LOAN_COMMITMENTS	YES	NO
IDX_FSI_D_LOAN_COMMITMENTS_5	FSI_D_LOAN_COMMITMENTS	YES	NO
IDX_FSI_D_LOAN_COMMITMENTS_4	FSI_D_LOAN_COMMITMENTS	YES	NO
IDX_FSI_D_LOAN_COMMITMENTS_3	FSI_D_LOAN_COMMITMENTS	YES	NO
IDX_FSI_D_LOAN_COMMITMENTS_2	FSI_D_LOAN_COMMITMENTS	YES	NO
FSI_D_LOAN_CONTRACTS	FSI_D_LOAN_CONTRACTS	YES	YES
IDX_FSI_D_LOAN_CONTRACTS_9	FSI_D_LOAN_CONTRACTS	YES	NO
IDX_FSI_D_LOAN_CONTRACTS_8	FSI_D_LOAN_CONTRACTS	YES	YES
IDX_FSI_D_LOAN_CONTRACTS_7	FSI_D_LOAN_CONTRACTS	YES	YES
IDX_FSI_D_LOAN_CONTRACTS_6	FSI_D_LOAN_CONTRACTS	YES	YES
IDX_FSI_D_LOAN_CONTRACTS_5	FSI_D_LOAN_CONTRACTS	YES	YES
IDX_FSI_D_LOAN_CONTRACTS_4	FSI_D_LOAN_CONTRACTS	YES	YES
IDX_FSI_D_LOAN_CONTRACTS_3	FSI_D_LOAN_CONTRACTS	YES	YES
IDX_FSI_D_LOAN_CONTRACTS_2	FSI_D_LOAN_CONTRACTS	YES	NO
IDX_FSI_D_LOAN_CONTRACTS_10	FSI_D_LOAN_CONTRACTS	YES	YES
IDX_FSI_D_SWAPS_9	FSI_D_SWAPS	YES	NO
IDX_FSI_D_SWAPS_8	FSI_D_SWAPS	YES	NO
IDX_FSI_D_SWAPS_7	FSI_D_SWAPS	YES	NO
IDX_FSI_D_SWAPS_6	FSI_D_SWAPS	YES	NO
IDX_FSI_D_SWAPS_5	FSI_D_SWAPS	YES	NO
IDX_FSI_D_SWAPS_4	FSI_D_SWAPS	YES	NO
IDX_FSI_D_SWAPS_3	FSI_D_SWAPS	YES	NO
IDX_FSI_D_SWAPS_2	FSI_D_SWAPS	YES	NO
FSI_D_SWAPS	FSI_D_SWAPS	YES	NO
IDX_FSI_D_TERM_DEPOSITS_9	FSI_D_TERM_DEPOSITS	YES	NO
IDX_FSI_D_TERM_DEPOSITS_8	FSI_D_TERM_DEPOSITS	YES	YES
IDX_FSI_D_TERM_DEPOSITS_7	FSI_D_TERM_DEPOSITS	YES	NO
IDX_FSI_D_TERM_DEPOSITS_6	FSI_D_TERM_DEPOSITS	YES	YES
IDX_FSI_D_TERM_DEPOSITS_5	FSI_D_TERM_DEPOSITS	YES	YES
IDX_FSI_D_TERM_DEPOSITS_4	FSI_D_TERM_DEPOSITS	YES	YES
IDX_FSI_D_TERM_DEPOSITS_3	FSI_D_TERM_DEPOSITS	YES	YES
IDX_FSI_D_TERM_DEPOSITS_2	FSI_D_TERM_DEPOSITS	YES	NO
IDX_FSI_D_TERM_DEPOSITS_10	FSI_D_TERM_DEPOSITS	YES	YES
FSI_D_TERM_DEPOSITS	FSI_D_TERM_DEPOSITS	YES	YES
LEDGER_STAT_9	LEDGER_STAT	YES	NO
LEDGER_STAT_8	LEDGER_STAT	YES	YES
LEDGER_STAT_7	LEDGER_STAT	YES	YES
LEDGER_STAT_6	LEDGER_STAT	YES	NO
LEDGER_STAT_5	LEDGER_STAT	YES	YES
LEDGER_STAT_4	LEDGER_STAT	YES	NO
LEDGER_STAT_3	LEDGER_STAT	YES	NO
LEDGER_STAT_102	LEDGER_STAT	YES	NO
LEDGER_STAT_10	LEDGER_STAT	YES	NO
LEDGER_STAT	LEDGER_STAT	YES	YES

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms