Re: Strange cost difference
Date: Sat, 19 Feb 2011 02:30:36 +0000 (UTC)
On Fri, 18 Feb 2011 09:30:16 -0800, joel garry wrote:
> Maybe I'm not understanding something, but isn't the idea for Oracle to
> figure out the best plan over time for each statement?
Actually no. Oracle 11 will collect statistics and replace the baseline in the SYSMAN tablespaces if and only if the plan costs less than the existing one. Oracle is not Watson, doesn't play Jeopardy with our SQL, it simply saves the plans and replaces them with cheaper plans. Although, speaking of Watson and intelligence, I predict that we will soon see multi-TB NVRAM devices, and the face of the computing will definitely change. Among other things, B*Trees may become obsolete.Received on Fri Feb 18 2011 - 20:30:36 CST