To Create Index for the Oracle Application Base Table.

Hi

The custom code has performance issue in oracle application. The query has running with Full Table Scan for the table. (Table Name: PER_ALL_ASSIGNMENTS_F and PO_POSITION_CONTROLS_ALL)

 

Query:

SELECT person_id

  FROM (SELECT   paaf.person_id, pcr.amount_limit

            FROM po_position_controls_all ppc,

po_control_functions pcf,

po_control_groups_all pcg,

po_control_rules pcr,

per_all_assignments_f paaf,

gl_code_combinations gcc

           WHERE ppc.job_id = paaf.job_id

             AND ppc.org_id = :b3

             AND pcf.control_function_id = ppc.control_function_id

             AND pcf.control_function_name = 'Approve Purchase Requisitions'