Re: Partitioning and Rule-based optimizer

From: Valery Yourinsky <vsu_at_bill.mts.ru>
Date: Mon, 17 Sep 2001 11:23:33 +0400
Message-ID: <3BA5A4F5.68A562A@bill.mts.ru>

Norm wrote:
>
> A client currently has an 8.1.7.10 database running in rule-based
> mode. We are thinking of implementing partitioning to help manage a
> few of their big tables. What features will be unavailable with
> partioning with RBO?

When Oracle met partition table in a query they use CBO. You should add hints to your query to garantee the same execution plan.

Valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia

Received on Mon Sep 17 2001 - 02:23:33 CDT