Re: Performance improvement for queries with IN clause

On 11/8/19 2:52 PM, Rafia Sabih wrote:
> Now, my question is shouldn't we always use this list in sorted order, 
> in other words can there be scenarios where such a sorting will not 
> help? I am talking about only the cases where the list consists of all 
> constants and could fit in memory. Basically, when we are 
> transforming the in expression and found that it consists of all 
> constants, then sort it as well, codewise at transfromAExprIn, of course 
> there might be better ways to accomplish this.
> 
> So, your thoughts, opinions, suggestions are more than welcome.

If it is worth sorting them should depend on the index, e.g. for hash 
indexes sorting would just be a waste of time.

Andreas