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 -> implications of merging 17 tables into 1...

implications of merging 17 tables into 1...

From: nirav <shivam71_at_gmail.com>
Date: Tue, 26 Jun 2007 11:16:59 -0700
Message-ID: <1182881819.399682.128830@i13g2000prf.googlegroups.com> 





Hi,



We have a data model and part of the applications' functionality is
there in a group of 17 tables to 20 inter related tables. Now there is
an initiative to redesign this piece entirely and the architect is
suggesting just one mega table instead of these 17! What could be the
pros and cons of this approach?



Does it mean that there will be more self joins for the same table and
writing queries for getting required data will be more complex?



What would be the right approach to analyze such a proposal?



With thanks,


Nirav
Received on Tue Jun 26 2007 - 13:16:59 CDT












Original text of this message













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