Re: Database Design Best Practice help
From: Sayan Sergeevich Malakshinov <malakshinovss_at_psbank.ru>
Date: Mon, 28 Jan 2013 13:35:58 +0400
Message-ID: <OFBE17AA36.E711061C-ON44257B01.003491BD-44257B01.0034E4E2_at_psbank.ru>
Hi, Jose!
Date: Mon, 28 Jan 2013 13:35:58 +0400
Message-ID: <OFBE17AA36.E711061C-ON44257B01.003491BD-44257B01.0034E4E2_at_psbank.ru>
Hi, Jose!
There are many negative points, beside of foreign keys/other constraints
as Toon Koppelaars already said:
IO by data dictionary, table and indexes will be increased independent of
it would be partitioned or non-partitioned table/indexes, CPU will be
increased if many triggers exists on these table even if their will be
with "when(TABLE_NAME="TABLE_N")", concurency for segment headers in case
of non-partitioned table and indexes, etc
Also independent maintenance more flexible.
PS. Sorry, i don't know what was with previous message
Best regards,
Sayan Malakshinov
http://orasql.org
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 28 2013 - 10:35:58 CET