>>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.
Thank you. I will Google for articles on this topic.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
