Re: OPTIMIZER_MODE=CHOOSE ???
From: Mark Driver <you_at_somehost.somedomain>
Date: 1995/06/07
Message-ID: <3r5928$7fs_at_server.cntfl.com>#1/1
Date: 1995/06/07
Message-ID: <3r5928$7fs_at_server.cntfl.com>#1/1
In article <3qmeb2$3hi_at_caladan.restena.lu>, Torsten.Fassian_at_eurostat.cec.be says...
>In my database the parameter OPTIMIZER_MODE is set to CHOOSE. Though I have
>never modified this parameter this is not the default value. According to the
>Administrators guide the parameter can only have the values RULE or COST.
My understanding of the CHOSE mode is that if statistics are available for the table (you analyzed it using estimate or compute statistics) the optimizer will use COST, otherwise it will use the older RULE based method.
hope this helps,
Mark Driver
Florida Department of Management Services
driverm_at_dms.state.fl.us
Received on Wed Jun 07 1995 - 00:00:00 CEST