Re: Database Design Best Practice help
- From: Sayan Sergeevich Malakshinov <malakshinovss@xxxxxxxxx>
- To: jose.soares@xxxxxxxxxxxxxx
- Date: Mon, 28 Jan 2013 13:35:58 +0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
