From rule based to cost based optimizer

From: Kimmo V{tt| <kimmo.vatto_at_ntc.nokia.com>
Date: 1996/02/21
Message-ID: <312ACB9D.43B5_at_ntc.nokia.com>#1/1

Hi everybody,

We are planning to move from rule based optimizer to cost based optimizer.
We have an environment with more that 1000000 LOC. The sql-clauses are pretty well optimised for the rule based optimizer. If you have knowledge of such operation I'd like to hear your opinions to
the following questions:

How much of the existing sql-clauses had to be changed? How did you spot the clauses that had to be changed? What happend to the overall system performance?

What other things should be taken into account?

Every tip will be greatly appreciated!

Kimmo Vatto
kimmo.vatto_at_ntc.nokia.com Received on Wed Feb 21 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Joe Greene: "Re: SQL*Net for Windows '95"
Previous message: Frank Kuhlmann: "Windows 3.1 : Is Forms unable to show all characters of a font ?"
Next in thread: Chris Fischer: "Re: From rule based to cost based optimizer"
Reply: Chris Fischer: "Re: From rule based to cost based optimizer"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message