Hi Suhas

What are you really trying to do? There is no value in creating multiple aopen arrays as each removes the previous one.

I can't believe the time spent building the .IDX is saving anything versus having the indexes. The set relation is not a factor. The SQL inside the scan ignores that and the SET ORDER TO 1 too.

>Select dist symbol from bhav_data into cursor dist1 nofilter && runs fast
>
>Select bhav_data
>index on symbol to symbol.idx
>set order to 1
>select Dist1
>set relation to symbol into bhav_data
>scan
> select open from bhav_data where symbol = dist1.symbol into array aopen order by date
>endscan
>
>*The above runs verry verry fast any tim first time or second time
>
>* tried variations
>* without setting the order and relation,
>* tried using already built IDX Or CDX instead fresh build
>* all the other methods runs very slow the first time and the n fast second time without restarting the system or VFP (maybe uses cached copy)