Re: Optimizer issue in 11g
From: amy <amykline_at_gmail.com>
Date: Fri, 19 Feb 2010 05:43:29 -0800 (PST)
Message-ID: <1d2ff2fd-1c65-4f67-a0ea-19020dda8b7e_at_s17g2000vbs.googlegroups.com>
Thanks everyone for your responses. The issue has not resurfaced after I posted this question. I was hoping to check out some of the suggestions posted here. We do not use SQL Baseline and our System Stats have not been re-gathered. I did not realize that Dynamic Sampling can happen even with Stats in place. Thanks Randolf for pointing that out. That might have contributed to the plan changes.
Date: Fri, 19 Feb 2010 05:43:29 -0800 (PST)
Message-ID: <1d2ff2fd-1c65-4f67-a0ea-19020dda8b7e_at_s17g2000vbs.googlegroups.com>
Thanks everyone for your responses. The issue has not resurfaced after I posted this question. I was hoping to check out some of the suggestions posted here. We do not use SQL Baseline and our System Stats have not been re-gathered. I did not realize that Dynamic Sampling can happen even with Stats in place. Thanks Randolf for pointing that out. That might have contributed to the plan changes.
Thanks. Received on Fri Feb 19 2010 - 07:43:29 CST