We have a Siebel implementation and for one query that was taking a long
time to run I asked a DBA to evaluate the explain plan. I noticed that
he chose to evaluate the Rule based optimization. I asked him why and
he said that the Siebel application defaults to Rule based optimization.
Not that I don't trust him, but I had the impression that Cost based was
the way to go.
Is it possible to set up a database schema so that it the optimizer
always uses Rule based rather than Cost ? And if anyone knows Siebel,
is this the actual default ?
Thanks.