Re: Database Design Best Practice help

From: Sayan Sergeevich Malakshinov <>
Date: Mon, 28 Jan 2013 13:35:58 +0400
Message-ID: <>

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

Received on Mon Jan 28 2013 - 10:35:58 CET

Original text of this message