creating composite index

[Arsalan]

Asalam Alycum Arsalan,


Oracle 11g

SIGTASDPS is TABLE IN Datawarehouse

NO DML OPERATION in this table

select * from sigtasdps s where refyear=1397 and s.tptcuocod='AF401' and s.companytin='9003927549'
and s.regno=10535 and s.hscode=87081000 and s.pkgnbr=12 and s.itemgrossweight=96;


should i create simple index for those columns which are used in where class  

OR


i should create composite indexes for those columns which are used in where class

what is your suggestion..


Thanks

[ErmanArslansOracleBlog]

We need to know the table structure? I mean the uniqueness of the columns.. The size of the table and etc..
According to the info, we may even create partitions on this table. (if there is not license problems)
In general, putting a unique index on unique column, which is used in the where condition will be enough to increase the performance of these types of queries.