> What (exact, if possible) version of Oracle?
My guess would be 8, but I'm not positive. I'm pretty sure they hadn't
upgraded to 9 yet, and they may have been back as far as 7 - yes, I'm
aware that's a pretty wide window. Anyway, they were using an
Oracle/Weblogic combo, and it didn't work as smoothly as they wanted it
to :)
Anyway, I know this discussion was on Oracle 9, but I just wanted to throw
out that the vendors use hype more than reality, and the chances that they
have something that is terribly better than what you could cook up at home
is remote. That's _why_ they don't publish the details. If you knew the
details, you wouldn't be nearly as excited.
Jon
>
> [snip]
> --
> +-----------------------------------------------------------+
> | Ron Johnson, Jr. Home: ron.l.johnson@cox.net |
> | Jefferson, LA USA http://members.cox.net/ron.l.johnson |
> | |
> | "Oh, great altar of passive entertainment, bestow upon me |
> | thy discordant images at such speed as to render linear |
> | thought impossible" (Calvin, regarding TV) |
> +-----------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>