Re: Oracle 7 Cost Base Optimizer
From: Dave Mausner <d-mausner_at_nwu.edu>
Date: 1995/05/14
Message-ID: <3p4ahu$h7k_at_news.acns.nwu.edu>#1/1
Date: 1995/05/14
Message-ID: <3p4ahu$h7k_at_news.acns.nwu.edu>#1/1
Recently, yobie_at_well.com (Yobie Benjamin) posted:
>Has anyone out there experienced inconsistent results between the same query
>run using cost based optimization and rule based optimization?
you may well perceive different results in a query run in both modes. it is not an inconsistency since the presumptions made in each mode are wildly different, and depend on how much good info about the environment is available to the optimizer.
-- Dave Mausner, Senior Consultant, Braun Technology Group, Chicago.Received on Sun May 14 1995 - 00:00:00 CEST