I just did a check on the help. Are you aware that when you open a view, if the table(s) are not already open, the dbc_AfterOpenTable event occurs twice? Once for the opening of the table and once for the opening of the view. That means you're doing the index procedure twice in that case.

In fact, if the view uses more than one table, then I suppose it will happen once for each table, and once for the view.

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)