Re: CBO Increase the Cost of Test tables.

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?

How did you exclude that the plan is optimal for large and small data sets in that table? IOW, why did you expect the plan to change? Maybe providing Ora version, DDL, query and plans help to get better feedback.

Kind regards

        robert Received on Tue Aug 22 2006 - 17:06:55 CDT