>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???
Yep, that's about it.
>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.
As I said, if that's the only index key, the index will be about 20% smaller. How much this will impact performance under your circumstances is hard to say. I think, however, you'll see a gain.
George
Ubi caritas et amor, deus ibi est