IN() and sorted lists

[Joseph_Seddik]

Hello,

Would IN() expression benefit from a sorted list to make faster? and in this case is there a way to tell IN() that the input list is sorted?

Thanks!

[WillowMobileSys · Accepted solution]

KJS:

Would IN() expression benefit from a sorted list to make faster? and in this case is there a way to tell IN() that the input list is sorted?

To be short…No and No.

[Joseph_Seddik]

“Brevity is the soul of wit” --Shakespeare

In other words, excellent answer
Thank you!