Re: View performance

From: Martin Dick <martin.dick_at_neis.com.au>
Date: Tue, 2 Jun 1998 17:30:11 +1000
Message-ID: <6l09kq$rsk$1@news.mel.aone.net.au>

stegri_at_rocketmail.com wrote in message <1104_896385456_at_ramirez_netlag>...
|Does anybody know if using views instead of tables affects performance?
|I've heard that view are in some way 'compiled' (although I don't
understand
|what is there to be compiled) and are even more efficient than retriving
|columns as 'normal' select-stmts.
|
|/Stelios Grigoriadis

As far as I know, the only real advantage in using a view is that the SQL is maintained centrally, and one which joins a lot of tables will mean that less SQL text has to be sent over the network to the server, thus reducing a possible bottleneck there. Received on Tue Jun 02 1998 - 02:30:11 CDT