I am an application developer working against an Oracle back end, so
please excuse my Oracle naivete.
- I have several unnormalized tables that I want to replace with
Views. When I do this, my application takes a major performance hit.
Not just on the first query using the view, but every time. Why?
- Can a view be a dynaset cached in RAM & only updated on a per-record
basis (eg when someone changes a fields contents). It seems now that the
view is a snapshot which is fully refreshed every time the view is
accessed. If this functionality is available, how do I implement it?
All comments are very appreciated.
Thanks in Advance
Joe
Received on Mon Sep 28 1998 - 13:08:23 CDT