>>
>>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
>>
>
>
I don't know if it's still true, but at one time, if SET EXACT and SET ANSI had different settings, it slowed things down. You might try making sure they're the same before your query.
Tamar