Re: is it possible to manufacture a query plan.

From: Lei Zeng <leizeng2003_at_yahoo.com>
Date: Thu, 23 Feb 2012 09:57:54 -0800 (PST)
Message-ID: <1330019874.14258.YahooMailNeo_at_web114706.mail.gq1.yahoo.com>

One simple method I would like to try is to manipulate the stats on the table to see if Oracle can go with my desired plan.
 

dbms_stats.set_table_stats
or
dbms_stats.copy_table_stats
 

Lei
DBspeed  http://www.dbspeed.com/index.html

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 23 2012 - 11:57:54 CST