Sure. If that works well (and there's no reason it shouldn't) then all is good. Are you opening the view NODATAONLOAD? If the view gets large the indexing could start to take a while.

Alan

>What I am using is the DBC Event AfterOpenTable to create the index.
>
>This is a store prcedure call automaticaly when the view is open.
>It work fine form me.
>
>>If you're using a Form's DataEnvironment to open the views automatically, then probably the simplest thing to do is to set the cursor's NoDataOnLoad to .T., and then in the form's init, do an INDEX ON for the view and then REQUERY the view.
>>
>>If any controls rely on it for source data then you'll have to requery or refresh them too.
>>
>>If you're opening them manually, then open then NODATA, and index them at that point.
>>
>>Alan
>>
>>>When you use a local updatable view there is no index on the table.
>>>
>>>I need to large query on the data and to speed it up I need indexs on the table.
>>>
>>>What is the best way to have index on the Local Updatable view?
>>>Where do I store the creation of index? (Store Procedure)