Re: Hinting the CBO

From: Robert Massey <rmassey_at_mindspring.com>
Date: Wed, 21 Nov 2001 19:27:02 -0500
Message-ID: <bbhovtsajdgftvtvad00vkvbg1ngmmjme8@4ax.com>

On Wed, 21 Nov 2001 21:25:42 +0100, Sybrand Bakker, wrote:

} As you don't show your hints no one will be capable to tell why they are
} ignored
} Please also note that when you use a table alias in the from clause you
} _must_ use this alias in your hint.

Thanks, I know to use aliases in the hints. The simplified SQL statement with hints is:

Select --+ USE_NL(p) ORDERED

  p.pfield1,
  p.pfield2,
  p.pfield3,
  c.sum_cfld3,
  c.sum_cfld4,
  c.sum_cfld5,
  c.sum_cfld6,
  c.sum_cfld7

From parent p, (
  Select
    cfield1,
    cfield2,

    sum(cfield3) sum_cfld3,
    sum(cfield4) sum_cfld4,
    sum(cfield5) sum_cfld5,
    sum(cfield6) sum_cfld6,
    sum(cfield7) sum_cfld7

  From child
  Group by cfield1, cfield2
  ) c
Where c.cfield1 = p.pfield1
  and c.cfield2 = p.pfield2
;

Once again, all suggestions welcome!

-- 
Robert

Nothing beside remains. Round the decay
Of that colossal wreck, boundless and bare
The lone and level sands stretch far away.
        -- Percy Bysshe Shelley, "Ozymandias"

Received on Wed Nov 21 2001 - 18:27:02 CST