Re: Many small tables vs. Few large tables

From: Jim Gregory <jim.gregory_at_daytonoh.ncr.com>
Date: 1996/10/17
Message-ID: <DzFJ25.B58_at_intruder.daytonoh.ncr.com>#1/1


"It depends!!!"

Either one can be a hog or give good performance. How is the data benig used? Frequence and type of extracts? Frequency, quantity, of updates, inserts, deletes?

There is no pat answer. Please provide more information.

Jim Gregory
>=========="Douglas Sur", 10/14/96==========
>
> Given one system with many small tables versus a system
>with a few large
>tables, which design is a more performance hog?
>
>

Opinions expressed are mine and do not reflect those of my company or clients. Received on Thu Oct 17 1996 - 00:00:00 CEST

Original text of this message