Re: partitioning

It is mostly true. CBO is "partition aware" and so can take advatage of the partition elimination feature. However, the performance benefits gained from breaking up an big object into smaller pieces and placing them on everal physical devices is not limited to CBO, of course. With RBO, you can do that without partitioning - basically create a union view on several smaller tables. Partitioning just makes it easier for you.

Performance is just one of the benetifs one gained from partitioning. Both CBO and RBO can benefit from high availability (since partition can be managed individually) and ease of administration with partitioining.

That said, it is likely nobody will be talking about RBO anymore in the not too distant future. So the whole discussion may become moot..

• Jusung Yang

daud11_at_hotmail.com (Daud) wrote in message news:<f0bf3cc3.0210280202.1be923bf_at_posting.google.com>...
> Someone told me this:
>
> Partitioning has no effect on performance unless the Cost Based
> Optimizer is used.
>
> Is that true? I find it a bit hard to believe but then I am not sure
> since I dont know much about partitioning.
>
> rgds
> Daud
Received on Mon Oct 28 2002 - 12:53:09 CST