creating composite index

Posted by Arsalan on Jun 23, 2018; 10:22am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/creating-composite-index-tp6249.html


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