Re: is it possible to manufacture a query plan.
- From: Lei Zeng <leizeng2003@xxxxxxxxx>
- To: "DHayden@xxxxxxxxxx" <DHayden@xxxxxxxxxx>
- Date: Thu, 23 Feb 2012 09:57:54 -0800 (PST)
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
- References:
- is it possible to manufacture a query plan.
- From: Dustin Hayden
- Re: is it possible to manufacture a query plan.
- From: Niall Litchfield
- RE: is it possible to manufacture a query plan.
- From: Dustin Hayden
- is it possible to manufacture a query plan.
Other related posts:
- » is it possible to manufacture a query plan. - Dustin Hayden
- » Re: is it possible to manufacture a query plan. - Niall Litchfield
- » Re: is it possible to manufacture a query plan. - joshuasingham
- » RE: is it possible to manufacture a query plan. - Holvoet, Jo
- » Re: is it possible to manufacture a query plan. - Ian Cary
- » RE: is it possible to manufacture a query plan. - Dustin Hayden
- » Re: is it possible to manufacture a query plan. - Lei Zeng
- » RE: is it possible to manufacture a query plan. - Shanmugam, Satheesh B