>>>>persistent or static ?
>>>>then I update the background view's tables and VFP update the view cdx automatically ?
>>>
>>>whenever you requery the view, index update automatically
>>
>>sure, but it writes the cdx fully, with 1 million records it is too slow.
>
>a 1-million record view is slow however, indexing makes no difference

The index is 99% static.
The table receives a handful of changes to minute intervals