From EShevtsov@flagship.ru Thu, 09 Aug 2001 17:43:36 -0700 From: "Shevtsov, Eduard" Date: Thu, 09 Aug 2001 17:43:36 -0700 Subject: Re: Optimizer Mode......how to choose the right one? Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 HaasOpus Consultants, LLC