Re: Table partitioning on 1 CPU, 1RAID controller - is it has a sense?

Oleg Fedorenkov wrote:
>
> Hi, All!
>
> I am in doubts.Table(index) partitioning on a system with 1 CPU, 1RAID
> controller - is it has a sense?
> Or it's worth to do it only on multyCPU and multidisk systems?
>
> With best regards,
> Oleg Fedorenkov

Having parallel processing etc etc is great for scanning many partitions at once, but partitioning can still be very useful on even the smallest of servers.

Partition elimination (where the optimiser can rule out the need to read one or more conditions) can dramatically improve the performance of table scans and the like...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse