RE: Many tables in a view.

From: Gait, Christopher <cgait_at_condor.nrl.navy.mil>
Date: Wed, 7 Jun 2000 16:46:25 -0400
Message-Id: <10521.108121@fatcity.com>

Jack,

Apart from being a giant, mutant view from hell, how large is the actual dataset returned by the view? Is it possible to have at least part of it in the form of a materialized view to eliminate a couple of joins? This could take up some storage, but you may be able to take a lot of time out your view return time. The drawback is that the best way of doing this is in 8i and you may not be there yet, and also that in 8i there is a fair amount of complexity invovled in making sure the materialized views (snapshots) update properly when the underlying tables are updated.

Also, there are a lot of indicators of a non-relational design in the attributes (so-and-so_1, so-and-so_2, etc.), is this deliberate denormalization for reporting purposes or is the DB design non-relational
(okay, I admit that Oracle itself isn't fully relational by the book, and
few and far between are the real-world databases where all is normalized as they 'should' be).

Christopher Gait
Oracle DBA

(Semi)permanent address: cjgait_at_yahoo.com
http://www.geocities.com/athens/3623

"Death is nature's way of saying: NEXT!" Received on Wed Jun 07 2000 - 15:46:25 CDT