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

Home -> Community -> Usenet -> c.d.o.server -> Re: CBO Increase the Cost of Test tables.

Re: CBO Increase the Cost of Test tables.

From: <sjaffarhussain_at_gmail.com>
Date: 23 Aug 2006 05:49:26 -0700
Message-ID: <1156337366.637858.286900@b28g2000cwb.googlegroups.com>


After setting manual stats to the table, did you check the cardinality, cost and bytes in the the exeuction plan?

Skoupal wrote:
> Hello,
>
> I'm working on a project to find a way to increase the cost of new
> tables using CBO. New tables are introduced in our development
> environments and usually don't contain a lot of rows. So I'm trying to
> find a way to trick the CBO into thinking the table was 1,000,000
> instead 1,000, which could possibly change the way oracle creates the
> explain plan. I need to be able to do this so when the table makes it
> way to our production database and has 1 million rows it will already
> be tuned.
>
> I tried using the DBMS_STATS.SET_TABLE_STATS but it didn't change the
> explain plan. Any other ideas I could try?
>
>
> Shawn
Received on Wed Aug 23 2006 - 07:49:26 CDT

Original text of this message

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