Thanks for the leg pulling, I needed that. Its legacy in that its an old database that just has had its Oracle RDBMS version upgraded to keep up with the desupport notice. The tables and the data is still many moons older. Its also legacy as it does not go to CBO and almost all tools in the marketplace these days assume you have CBO. So there. Vikas ----- Original Message ----- From: rjamya To: gorbyx@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Sent: Tuesday, November 08, 2005 11:19 AM Subject: Re: Partitioning in 9.2 without ANALYZING tables Welcome to the 21st Century. 8:) Raj On 11/8/05, Alex Gorbachev <gorbyx@xxxxxxxxx> wrote: > We have a legacy oracle 9.2 database... Wow! Legacy? Well, we consider it's the only option for really HA environemnt until at least middle 2006. -- Best regards, Alex Gorbachev