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.