Hi,

why is this subquery dependent?

SELECT * FROM SYSlogs.pflog WHERE chargedomain IN (SELECT target FROM
SYSconf.aliasdomains WHERE name IN ('xxx','yyy','zzz')) OR
chargedomain=0

1 | PRIMARY | pflog | ALL | chargedomain | NULL | NULL | NULL |
5659150 | Using where
2 | DEPENDENT SUBQUERY | aliasdomains | ALL | name | NULL | NULL |
NULL | 92 | Using where

Regards,
André

On 5 Dec, 23:20, "André Hänsel" <an...@webkr.de> wrote:
> Hi,
>
> why is this subquery dependent?
>
> SELECT * FROM SYSlogs.pflog WHERE chargedomain IN (SELECT target FROM
> SYSconf.aliasdomains WHERE name IN ('xxx','yyy','zzz')) OR
> chargedomain=0
>
> 1 | PRIMARY | pflog | ALL | chargedomain | NULL | NULL | NULL |
> 5659150 | Using where
> 2 | DEPENDENT SUBQUERY | aliasdomains | ALL | name | NULL | NULL |
> NULL | 92 | Using where
>
> Regards,
> André

I don't know, but why are you using a subquery when a JOIN is far
superior?