Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: implications of merging 17 tables into 1...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
nirav wrote:
> 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
>
Lemme guess - java development going on?
Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
iD4DBQFGgq0XLw8L4IAs830RAlRlAJ9k7+phdBeLQne5ahf84FOx8LapNgCXXUo6
mefOX+1XPVnX5rPO4qZVdQ==
=qIv4
-----END PGP SIGNATURE-----
Received on Wed Jun 27 2007 - 13:31:51 CDT
![]() |
![]() |