>>>
>>>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
>

No the result is the same. the above doesnt make any difference.
Can u hilight what u mean by cashing effect ? what is going on ?