List:General Discussion« Previous MessageNext Message »
From:Harald Fuchs Date:November 10 2002 1:16pm
Subject:Re: MySql 4.1 Sub Selects
View as plain text  
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]
Thread
MySql 4.1 Sub SelectsGreg Matthews10 Nov
  • Re: MySql 4.1 Sub SelectsJeremy Zawodny10 Nov
  • Re: MySql 4.1 Sub SelectsGreg Matthews10 Nov
    • Re: MySql 4.1 Sub SelectsJeremy Zawodny10 Nov
  • Re: MySql 4.1 Sub SelectsJocelyn Fournier10 Nov
  • Re: MySql 4.1 Sub SelectsGreg Matthews10 Nov
    • Re: MySql 4.1 Sub SelectsJeremy Zawodny10 Nov
  • Re: MySql 4.1 Sub SelectsHarald Fuchs10 Nov
  • Re: MySql 4.1 Sub SelectsGreg Matthews10 Nov
  • Re: MySql 4.1 Sub SelectsMichael T. Babcock11 Nov
  • Re: MySql 4.1 Sub SelectsGreg Matthews11 Nov
RE: MySql 4.1 Sub Selectsdaniel11 Nov
  • re: RE: MySql 4.1 Sub SelectsVictoria Reznichenko11 Nov
    • RE: RE: MySql 4.1 Sub SelectsDan Rossi11 Nov
      • Re: RE: MySql 4.1 Sub Selects and not stored proceduresGreg Matthews11 Nov
        • RE: RE: MySql 4.1 Sub Selects and not stored proceduresArthur Fuller11 Nov
          • Re: RE: MySql 4.1 Sub Selects and not stored proceduresGreg Matthews11 Nov
        • Re: MySql 4.1 Sub Selects and not stored proceduresDan Nelson11 Nov
        • Re: RE: MySql 4.1 Sub Selects and not stored proceduresJohn Ragan11 Nov
      • Re: MySql 4.1 Sub SelectsMichael T. Babcock11 Nov
re[2]: MySql 4.1 Sub SelectsRichard Morton11 Nov
  • Re: re[2]: MySql 4.1 Sub SelectsLenz Grimmer11 Nov