>>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.