Performance of Views
From: Paul Power <paul.power_at_rssi.com>
Date: 1996/03/29
Message-ID: <4jgmvi$ajp_at_lal.interserv.net>#1/1
Date: 1996/03/29
Message-ID: <4jgmvi$ajp_at_lal.interserv.net>#1/1
We are using several views in or database. They include joining 15 tables, 40 columns, and contain
around 1000 rows. There is a debate going on as to how these views are handled by the database. We
are accessing these view from reports and our GUI. Do the views get destroyed after use - or do they stay
in memory until they are pushed out. Are they a performance hit on the database server if several users are
accesssing them at the same time ?
Any help is appreciated
Paul
Received on Fri Mar 29 1996 - 00:00:00 CET