Can someone tell me where to find (I looked the docs over, honest)
what the default is for Oracle 7.x as far as optimizer_mode ?
I believe you can put a number of parameters in the initorcl.ora file
to set this, but I don't know what the system does if the parameter is
missing.
Oracle 8, I found out, defaults to "optimizer_mode=choose", unless
statitistics are not available. In that case it uses rule-based
instead.
Thanks
Jeff Kish