Home » RDBMS Server » Server Administration » Stored Outline
Stored Outline [message #346851] Tue, 09 September 2008 21:05 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
I have oracle 10gR2 database. I have problem with one query which runs fast when i set optimizer_mode=first_rows;

So I decided to generate a outline after setting alter session set optimizer_mode=first_rows; But after using the outline when i look at the plan, it is still different. Can anyone tell me what the problem is? This is what I'm doing-->

1. alter session set create_stored_outlines = TEST
2. alter session set optimizer_mode=first_rows;
3. CREATE OUTLINE GOOD FOR CATEGORY TEST
on <SQL>;
4. alter session set create_stored_outlines=FALSE;
5. ALTER SESSION SET USE_STORED_OUTLINES=TEST;
6. Run the Query and look at the Plan --> plan is not good
The plan is different from the Good plan which I get when i do-->

1. alter session set optimizer_mode=first_rows;
2. Run the Query and check the Plan --> this plan is good.

Thanks.
Re: Stored Outline [message #346852 is a reply to message #346851] Tue, 09 September 2008 21:12 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

Since you choose to ignore posting guidelines, we choose to not answer your question(s).
Previous Topic: Logs to Check When Db Gets Completely Crashed
Next Topic: Post upgrade to 10.2.0.4 - a new listener
Goto Forum:
  


Current Time: Sat Dec 03 06:18:39 CST 2016

Total time taken to generate the page: 0.13403 seconds