>>
>>An Index caching overload effect ?
>>
>>try, and post this time:
>>

>>use bhav_data
>>SET EXACT ON
>>=lOOKUP(symbol, m.THISVALUE,symbol)
>>SELECT date,open,high,low,close,tottrdqty,sma9,sma12,sma26 FROM bhav_data;
>>where symbol = m.THISVALUE  INTO CURSOR tempDETAIL nofilter
>>

>
>
>Minimum time taken is 9 secs
>
>but if i run the second time with the same value in thisvalue it runs under .5 secs
>
>like
>
>First run with thisvalue = 'ABCD' -- 10 secs
>second run with thisvalue = 'dfsd' -- 10 secs
>third run with thisvalue = 'ABCD' -- .5 secs
>
>that is wilhout cloing the table

this confirm the caching effect.

try

SELECT date,open,high,low,close,tottrdqty,sma9,sma12,sma26 FROM bhav_data;
where symbol = m.THISVALUE AND symbol = symbol INTO CURSOR tempDETAIL nofilter