Re: one table with lots of records or more table with less records

From: Breno de Avellar Gomes <brenogomes_at_ieee.org>
Date: Sun, 06 Jun 1999 02:48:16 +0100
Message-ID: <3759D360.19E8879@ieee.org>

If you are using Oracle8 my suggestion is to use one partitioned table. Assuming an usual system, such as billing, you can define partitions for each period.
Depending on the number of records, each period may be limited to year, quarter or month.

Using different physical disks to store tables and indexes also can be helpful.
Machines with multiple processors can perform parallel query, with improve the overall performance.

Regards

bgumus_at_my-deja.com wrote:

> HI,
>
> We're creating a big database, and I have a question. What do you all
> think; you better have a big table with 1 billion records or 1000
> tables with 1 million records?
>
> Which one is easier to access and get the data?
> And which one requires less database space?
>
> Thanks in advance.
> Bulent Gumus
> bgumus_at_onboard-software.com
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Received on Sat Jun 05 1999 - 20:48:16 CDT