index creation

Hi Experts,

I have a table with 36978 records.

A full table scan happens on the table with below filter predicate

filter(("CHT"."PROPERTY_ID"=:B2 AND "CHT"."PARTY_ID"=:B3 AND "CHT"."CHALLAN_DATE">:B1 AND  "CHT"."ATTRIBUTE2"='A'))

We want to like to create index on all the columns.

In which order, shall we create the index. Here there is a CHALLAN_DATE column.

Please suggest.

COLUMN_NAME          NUM_DISTINCT LOW_VALUE      HIGH_VALUE      HISTOGRAM    NUM_NULLS
------------------------------ ------------ -------------------- -------------------- --------------- ----------
PROPERTY_ID              3563 C117         C2563D        NONE           0
PARTY_ID                3558 C24A5A        C3022B02       NONE           0
CHALLAN_DATE              1173 7877040F010101    787B0807010101    NONE           0
ATTRIBUTE2                2 41          56          NONE           7