Re: merging small tables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 03 Aug 2002 08:47:37 +0200
Message-ID: <b2vmkugjnpqnm6rs1nr10u49obclj6huum@4ax.com>

On Sat, 3 Aug 2002 00:02:47 +0200, "Stjepan Brbot" <stjepan.brbot_at_zg.hinet.hr> wrote:

>I have a lot of small tables of type [no,itemname] having few (3-10)
>records and those tables will never be bigger! Regarding the performance
>and rationality of using DB space, is it better to create a new table of
>type [domain,no,itemname] and merge all records from small tables and
>distinguishing them by domain?

It is better to follow data-modelling and normalization rules and not trying to be 'smart'

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Aug 03 2002 - 01:47:37 CDT