Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Kevin,
>
>When opening views, it matters if the underlying tables are already opened or not.
Kevin,
In the testing report the table was open.
I tested that case with
use myviewname a 100 times and measure the time
With closing the table with
use myviewname
use
use in myviewtable
it is 60 to 70% slower
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only