In article <014701c288a4$1b1bb550$0100a8c0@dev>,
"Greg Matthews" <greg55@stripped> writes:
> Your call. If a 4.1 binary was available then I'd spend time testing it with
> a J2EE app under JBoss on Windows XP -- otherwise i'll just have to wait.
> 95% of the subselects I do are simple correlated subqueries like this:
> select <columns>
> from tableA
> where exists (
> select 1
> from tableB
> where tableB.myCol = tableA.myCol
> )
> or
> select <columns> from tableA
> where exists (
> select 1
> from tableB
> where tableB.myCol = tableA.myCol
> and tableB.someCol in ('A','B','C')
> )
Why don't you simply convert these queries to ordinary JOINs?
Me thinks that's easier than experimenting with unoptimized pre-alpha
code.
[Filter fodder: SQL query]
