Re: Optimizer Mode......how to choose the right one?

[Shevtsov, Eduard]

Title: Message

Hi Steven,   it depends on what optimizer will actually work with your particular statement. Yes for RBO (in fact, in some cases) No for CBO (except 'hard' cases when default number of permutations (80.000) is not enough)   Regards, Ed   Does the order of tables also make a difference with a RULE hint?   Steven Haas Opus Consultants, LLC