Re: Hash join order

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 28 Mar 2003 20:15:23 -0000
Message-ID: <b62ahf$rgo$1$8302bc10@news.demon.co.uk>

Worried ? Perhaps.
Surprised ? Not particularly.

Last time I checked there were about
60 documented hints and a similar
number of undocumented hints.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____UK_______April 8th
____UK_______April 22nd
____Denmark__May 21-23rd
____USA_(FL)_May 2nd

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK_(Manchester)_May
____Estonia___June (provisional)
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Richard Kuhler" <noone_at_nowhere.com> wrote in message
news:dy1ha.8433$Hx.3752282_at_twister.socal.rr.com...


> Jonathan Lewis wrote:

> <snip>

> > then you need to include the hint

> >     swap_join_inputs(table_a)

> > in the select statement (you may also need to

> > include an index(table_c) for the test case you

> > published).

>

> Thank you!  That worked.  Should I be worried that I can't find this

> hint in the documentation?

>

> Richard Kuhler

>

Received on Fri Mar 28 2003 - 14:15:23 CST