Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to estimate number of subpartition
maniekp wrote:
> hello,
>
> Can anybody know what is the main factor of estimating
> number of subpartitions. I have fact table with one-day partitions
> , each day about 1M rows. Machine have 20 CPU, but when I set up
> 20 subpartitions that in each segment will be only 5k rows ...
>
> thx, maniek
>
thanks all ;)
Received on Wed Jun 04 2003 - 18:37:30 CDT