The complete answer is probably "it depends", but this does not help
much...:-)
I would try out the simple approach first (i.e one 50 million row
table), but read up about :
i) partial indexes and maybe
ii) clustering
iii) think about presorting the data before loading to place "likely to
be a
On Wed, 2004-05-19 at 15:37 +0800, Michael Ryan S. Puncia wrote:
> Hi Guys,
>
>
>
> My question is .. which is better design
>
>
>
> 1. Single Table with 50 million records or
> 2. Multiple Table using inheritance to the parents table
It's not that simple.
Given your e-m
Hi Guys,
My question is .. which is better design
Single Table with 50 million
records or
Multiple Table using
inheritance to the parents table
I will use this only for query purpose ..
Thanks ..
