Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

djberg96 (2603)

djberg96
  (email not shown publicly)

Journal of djberg96 (2603)

Friday September 24, 2004
04:47 PM

Hash AntiJoins - I give up

[ #21042 ]
Even after runrig provided a handy link to try to force Oracle to pick up the HASH_AJ hint, I'm not having much luck. Of the four queries I tried to tweak, three would not pick up the hint no matter what I tried. The fourth one saw a minimal improvement but the query was very ugly with all the "is not null" added.

So, the moral of the story is, just use "minus". :)

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.