Re: CBO Increase the Cost of Test tables.

"Skoupal" <smk36_at_dana.ucc.nau.edu> wrote in message news:1156283538.688658.221980_at_m73g2000cwd.googlegroups.com...
> 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
>

Did you also use

    dbms_stats.set_index_stats
    dbms_stats.set_column_stats

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html