Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
Bit confused here. Is the SQL faster or the view?
Anyways, using a view also reads from the database. If the database is on the network, it is expected that reading from the view is slower. But there is more to it. If you specify a database(!) prefix in the from clause it is reading more from the network than when reading from an already open alias.
Walter,
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