Hi all,
I am wondering if in SQLITE the EXISTS clause is expanded and optimized
in any way.
This is generated by the observation that 2 algebrically equivalent queries,
SELECT WHERE EXISTS ()
and
SELECT WHERE id IN (SELECT ...)
produce different execution plans and different performance, with WHERE
id IN (SELECT ) looking properly optimized.
We could not find any reference to this in
https://sqlite.org/optoverview.html
Thanks,
Dinu
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
