CBO Increase the Cost of Test tables.

From: Skoupal <smk36_at_dana.ucc.nau.edu>
Date: 22 Aug 2006 14:52:18 -0700
Message-ID: <1156283538.688658.221980@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 Received on Tue Aug 22 2006 - 16:52:18 CDT