Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Partitioning in 9.2 without ANALYZING tables

Re: Partitioning in 9.2 without ANALYZING tables

From: David Sharples <davidsharples_at_gmail.com>
Date: Tue, 8 Nov 2005 16:33:31 +0000
Message-ID: <be592d550511080833r64a85aaaredc00578892d1148@mail.gmail.com>


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_at_hotmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 08 2005 - 10:35:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US