Re: Any side effect of having opened tables while using the local views?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Willianto wrote: 
Hi Stefan,
Thanks for your reply.

[...skipped]


On the other hand, I believe there is no advantage in doing so.


hth
-Stefan



Just to make sure: not even relate to a table corruption problem? I
mean, if the table is open,


Actually if you close the table each time it gets opened, you will incurr a lot of additional overhead. Each time a local view is refreshed, updated etc, it will open the base tables that it is based on. If you close it each time, it's just going to have to open the table again the next time you do anything that looks at or updates the data. My experience has been that it's actually better to leave the tables open (from a data transfer and performance viewpoint).
.

Relevant Pages