On 25.07.2017 00:17, PT wrote:
> The IN clause is not what's taking all the time. It's the processing of
> millions of rows that's taking all the time.
IN (...) - 17 sec
IN (VALUES ...) - 4 sec
So performance issue is with IN-clause.
> Perhaps you should better describe what it is you really want to accomplish.
> Regardless of what it is, if it involves processing many millions of rows,
> you're probably going to need to do some sort of materialization.
I try to find better solutions for IN-task.