Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: partitioning
Thought I read somewhere that Oracle automatically uses cost based
optimizer when it encounters partitioned tables. Never tested it
since I've always used CBO.
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 Tue Oct 29 2002 - 14:12:14 CST