>>I have a form that takes a fair amount of time to open. I added a
>>set talk on nowindow
>>to the BeforeOpenTables method to display what is happening.
>>
>>One table/view is taking a long time to open, however I would like to know what it is.
>>
>>How do I do this, the above talk command doesn't give me the alias(), just how long the queries take...
>>
>>Any ideas?
>>
>>TIA,
>>Mike
>
>SET COVERAGE TO may give you something but the surest way would be taking views one by one out of DE and checking time again.
By further investigation, one of the views had a parameter and there was no index on the repective fields... creating index - speed things up to fractions of a second...

Thanks,
Mike