Re: Performance & PL/SQL

PL/SQL has a great performance for all the procedures I ve written so far.

If you need the "denormalized" view for your access query, you have to provide this view. The problem is, that the select statement, which describes the view, is run every time you access the view.

Maybe a possible solution to your problem could be in building a real table, that has the same structure as the view. This table could be maintained by Oracle
Triggers, which are fired every time you manipulate a table that holds information
relevant for this view ( Table).

In these triggers you can use all the elements of the PL/SQL language.

Hope this helps,

Christian Metzler
cme_at_magnet.at Received on Thu Oct 26 1995 - 00:00:00 CET