Create Index To Run Fast Query

1)  Run Below query

  select * from ap_invoices_all where source='OHI CLAIMS'

time taking :- 5 Sec

Now Create Index

 create index XXDM_OHI_CLAIM_INV_idx
    on AP_INVOICES_ALL (SOURCE,
          INVOICE_RECEIVED_DATE,
          INVOICE_DATE,
          PAY_GROUP_LOOKUP_CODE,
          INVOICE_ID,
          INVOICE_AMOUNT)
     compute statistics;

2) Run Below Query Now

       select * from ap_invoices_all where source='OHI CLAIMS'

time taking :- 254 MiniSec