Re: Individual Type Code tables vs. one big one

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/11/05
Message-ID: <55neio$4q4_at_newton.pacific.net.sg>#1/1

If you have one table, it becomes easier for the DBA in maintenance.

If you have more tables (30 in your example) the database administration is more combersome.

Moreover if more tables are there, the data dictionary cache is filled with lot of tables instead of one table. By saving space in the data dictionary cache, shared memory is utilized properly thus improving performance.

Regards

N.Prabhakar Received on Tue Nov 05 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Jack L. Swayze Sr.: "Re: Individual Type Code tables vs. one big one"
Previous message: Jeff Dellinger: "US-MANY LOCATIONS-ORACLE SW/ENGINEERS & DBA'S-PERM"
In reply to: Kevin Merritt: "Individual Type Code tables vs. one big one"
Next in thread: Jack L. Swayze Sr.: "Re: Individual Type Code tables vs. one big one"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message