if you use partitioning, you will be using the CBO as the RBO cannot deal with it I believe. So you better has generate some stats On 11/8/05, Vikas Gautam <g_vikas@xxxxxxxxxxx> wrote: > > My question is whether this is true and unless we analyze the tables > first (and move to CBO) we cannot do partitioning. > Thanks > Vikas >