Oracle-L: Cost optimizer on NT -Reply

From: GARY MELHAFF <GMJJ490_at_GWGATE.WADNR.GOV>
Date: Thu, 1 Feb 1996 09:15:34 -0800
Message-Id: <9602011724.AA08002@alice.jcc.com>

You have to also run "analyze" command on every table (and index) or optimizer will default to rule based instead.

>>> Tribble Dave <DLT3716_at_KCPL.COM> 02/01/96
09:47am >>>
I'm running Oracle V7.2.2.4 on an NT platform and I find the cost optimizer is making a bad decisions (such as told me to take Pittsburgh straight up,
not to mention bad query resolution paths). OPTIMIZER_MODE is set to
CHOOSE. This is the right setting for COST based isn't it? I thought the idea was for the optimizer to get SMARTER with each release. ?
Anyone no of reported bugs on this?

Input appreciated dlt3716_at_kcpl.com Received on Thu Feb 01 1996 - 12:24:21 CST