Re: Cost-based Optimizer
Date: 1996/02/04
Message-ID: <4f352c$iar_at_reader2.ix.netcom.com>#1/1
alc_at_nyx (Alain Cheong Chun Lin) wrote:
>Hello Everyone,
>I need some comments from people who are using the cost-based optimizer. We
>are running Oracle 7.2 on SunOs 4.1.3. Up to now we stick with Rule-based and
>we are doing fine so far. I have decided to try out the cost-based optimizer,
>with lots of care, since I have heard some negative comments on that
>optimizer, especially the earlier versions of Oracle 7. I would love to get
>some feedback from people who are using cost-based. Is it better ? Can we
>move to cost-based blindfolded ? Are there any situations where cost-based is
>not recommended ?
>Alain Cheong
>alc_at_logibec.com
We switched to cost-based almost two months ago on 7.1.3, 7.1.4, and 7.1.6 in a distributed data warehouse environment. Every query we tested ran faster with cost based (FIRST_ROWS to be specific) as opposed to rules based.
-- Chuck Hamilton chuckh_at_ix.netcom.com If at first you don't succeed, sky-diving isn't for you.Received on Sun Feb 04 1996 - 00:00:00 CET