RE: performance -views

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 28 Jun 2000 21:34:40 +1000
Message-Id: <10542.110633@fatcity.com>

Hi Paul,

View definitions are not cached. They are read from the data dictionary for every parse operation, which increases parse costs significantly. That should be a significant incentive for avoiding them in an intense OLTP system. There are also potential optimization issues, but those are unlikely to be of concern in your case.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/


-----Original Message-----
From:	Paul Sehgal [SMTP:Paul.Sehgal_at_radiantnetworks.co.uk]
Sent:	Wednesday, June 28, 2000 6:43 PM
To:	Multiple recipients of list ORACLE-L
Subject:	performance -views

Hi,

   I'm designing a database which will be very transcactional. What are the performance implications in using views instead of allowing direct access to a table? My wvews would be a select * from each table. Thanks,
Paul Sehgal.

---

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system administrator mailto:postmaster_at_radiantnetworks.co.uk

---

Received on Wed Jun 28 2000 - 06:34:40 CDT