What index do I need for this query ?

From: <krislioe_at_gmail.com>
Date: Tue, 24 Mar 2009 16:04:46 -0700 (PDT)
Message-ID: <c9bb83fe-bee2-49c5-9df7-eb70c4c2551c_at_s38g2000prg.googlegroups.com>

Hi gurus,

I have the query like below :

   SELECT INVH.REGS_CODE, INVH.CUST_CODE, INVH.TAXDATE, INVH.TAXNO, INVH.INV_ID, INVH.INV_NO, INVH.INV_DATE,            INVH.LOC_CODE, INVH.LOCGRP_CODE, NVL(INVH.DISCBM_RP,0) AS EXT_DISCOUNT,

	   INVH.GROSS AS GROSS_HDR, NVL(INVH.VAT,0) AS VAT_HDR,
                  INVH.NETTO AS    NETTO_HDR,   INVH.FLG_PPN_DP
 FROM INVOICE_H INVH
     WHERE INVH.INV_NO  BETWEEN :InvoiceNumber AND :InvoiceNumberUpto

   AND INVH.TAXNO BETWEEN TRIM(SUBSTR(:TaxNoFr,3)) AND TRIM(SUBSTR (:TaxNoTo,3))

   AND INVH.TAXDATE BETWEEN TO_DATE(:TaxDateFr,'DD-MM-YYYY') AND TO_DATE(:TaxDateTo,'DD-MM-YYYY') AND

     INVH.CUST_CODE BETWEEN :CustFr AND :CustTo AND
     INVH.REGS_CODE BETWEEN :RegsFr AND :RegsTo AND
INVH.TAXCODE<>'GAB'
             AND NVL(INVH.TAXNO,' ')<>' '

What index can help this query to perform ?

Thank you very much,
xtanto Received on Tue Mar 24 2009 - 18:04:46 CDT