Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Maintaining Stock Availibility : physical table or materialized view ?

Re: Maintaining Stock Availibility : physical table or materialized view ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 07 Sep 2006 07:10:46 +0200
Message-ID: <6davf2h025iqhciu1sim538eg5bao3alos@4ax.com> 





On 6 Sep 2006 17:10:08 -0700, krislioe_at_gmail.com wrote:



>We are really tempted to use JUST view /materialized view to maintain

>stock position.

>(where traditionally we use a phiysical table for this, updated after

>insert/update/delete of transactions)





Why on earth? The view will need to be updated with every INSERT,
UPDATE, DELETE!

 

--
Sybrand Bakker, Senior Oracle DBA


Received on Thu Sep 07 2006 - 00:10:46 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US