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

From: John Higgins <JH33378_at_deere.com>
Date: Fri, 04 Jun 1999 20:16:44 -0500
Message-ID: <37587A7C.A727B80C@deere.com>

How about:

One table with 1000 partitions?

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 Fri Jun 04 1999 - 20:16:44 CDT