Re: AW: AW: AW: [HACKERS] Some notes on optimizer cost estimates

Philip Warner wrote:
> 
> At 10:14 26/01/00 -0800, Don Baccus wrote:
> >At 01:25 PM 1/26/00 +0100, Zeugswetter Andreas SB wrote:
> >
> >>Yes, I think syntax to force or disallow a particular index,
> >>choose a join method or order, force/disallow seq scans ...
> >>is sometimes useful.
> >>Even Informix, who always refused to supply such a feature
> >>now has it.
> >
> >Can you give some sample syntax, for those of us who aren't
> >really database people but merely trying to maintain a facade? :)
> 
> There are two schemes I know if, one is the Microsoft (and I think Orcale)

IIRC Oracle hides the optimiser hints in comments, at least it does not 
directly sabotage portability.

I just remember reading an article about this in a magazine, have never used 
it myself.

-----------
Hannu