I'm not sure what index bloat means???? We have re-indexed many times, re-created indexes many times. The views are built into the dbc and as far as I know just using the select statement from the command window produces the same performance. Recall that I'm talking about a very simple test using custno. SBT, skyline, etc use the same index tag - just plain custno - on the table arcustXX. We have tried moving the table to MS-SQL on a test computer and found a marked improvement. But to get the performance really wanted we have used seek's. I wish fox advisor would do a test on this type of situation. And of course find how, why and when views are slow using foxpro tables. Thanks for your help. In fact today (sat) we will be doing more testing because it is driving us crazy.
John