So "Select * from table order by SKU to cursor mytemp
Dele sku.dbf
Select mytemp
copy all to sku.dbf
index on sku tag sku = smaller index?
Is that something near what your saying???
The reason I'm asking is I have a client with of 6G of data at the moment. There is one area of the code that is very slow and I believe it is due to the size of the index. I have discovered that code contains a view and the requery request transfers the entire index before displaying the results.
John
>By re-ordering the table by SKU and then re-building the index, it (the index) will be up to 20% smaller. I'm not talking about huge amounts of records either. I've seen this occur when there are 1,000-2,000 records.
John Fabiani
Woodland, CA