Thomas Kellerer writes:
> Lately I had some queries of the form:
> select t.*
> from some_table t
> where t.id not in (select some_id from some_other_table);
> I could improve the performance of them drastically by changing the NOT NULL
> into an outer join:
> select t.*
>
On Thu, Jul 19, 2012 at 4:43 PM, Thomas Kellerer wrote:
>delete from some_table
>where id not in (select min(id)
> from some_table
> group by col1, col2
> having count(*) > 1);
>
> (It's the usual - at least for me - "get rid of
Hi,
(this is not a real world problem, just something I'm playing around with).
Lately I had some queries of the form:
select t.*
from some_table t
where t.id not in (select some_id from some_other_table);
I could improve the performance of them drastically by changing the NOT NULL
i
