Re: script taking time

Posted by Roshan on Jun 06, 2018; 3:59am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/script-taking-time-tp6155p6174.html

Can you please guide me on which columns to set the index?

select * from mobile_data@newarchicom --where time >= to_date('01/09/2012 00:00:00' , 'DD/MM/YYYY HH24:MI:SS') --and time <= to_date('30/09/2012 23
:59:59' , 'DD/MM/YYYY HH24:MI:SS') where substr(cdrfilename, 1,15) between '3g3glf_00124907' and '3g3glf_00125968' and postpre = 'roa');

For example in the fist query?