Hi Bernard,
Use SYS(3054,1) and SYS(3054,11) to find out the places from where the query is not being optimized.
>I have this table with about 90,000 records. The table is about 47 mb in size.Some of the fields are Invoice number, invoice date, active flag. If I do a select on these fields as so:
>
>SELECT inv_number from INVTable WHERE YEAR(inv_date) = 1997 and REC_active into a cursor/table/array
>
>There is an index on inv_number and the table is type FPW2.6
>
>The result set is about 30000 records. In VFP 5.0a this is slow. Takes about>2 mins and sometimes runs out of memory if into an array. I read somewhere some time ago that there is a sys() function that improves the memory management of vfp and speeds up the select.
>
>I dread to think what would happen if I needed to extract from 2 tables using a join condition!
>
>Does someone out there working with large tables have any ideas? A view is not what I'm looking for, parametised or otherwise.
>
>Thanks in advance
>
>Bernard