>But
>
>set exact on
>SELECT date,open,high,low,close,tottrdqty,sma9,sma12,sma26 FROM bhav_data;
>where symbol = m.THISVALUE and date =date() INTO CURSOR tempDETAIL
>
>SELECT date,open,high,low,close,tottrdqty,sma9,sma12,sma26 FROM bhav_data;
>where symbol = m.THISVALUE INTO CURSOR tempDETAIL nofilter
>
>this both combined runs under 1 secs

The second query above is the same as the other two that you say run in 3 secs. You have a number of things here that can affect the time, one how many reocrds are returned? two using nofilter option.