Re: Optimizer question in 7.3

>The query ran horribly slow until we either changed the optimizer to run in
>RULES mode or placed a hint to use RULES mode on this query.

You should use RULE optimizer unless you have up to date statistics on all your schema. Otherwise, the COST optimizer won't do correct decisions.

If you want to check the difference between the plans, download a TunaSQL demo from DBE site (www.dbesoftware.com) and run it with your SQL.

If you need any assistance, I will be happy to provide it at morgan_at_cardume.com .

CardumeSoftware
www.cardume.com Received on Fri Oct 31 1997 - 00:00:00 CST