>First, thank you.
>Is compound index (never done it before) would be something like this (using VFP syntax):
>index on REC_ID + STR(ORDER_NO,10)
>?
It is a totally different architecture. You are allowed to include up to 16 fields for the index and as much as you want for the include.
You might read on documentation for creating those indexes, first in regards to the order of the indexed fields and in what fields need to be included. If you modify the required select which has a use for that later on, you always have to think about why you created this index and see if you have to update it. This could be the difference between light and day such as instant versus 10-minute queries.