will using

IdSet

with “NOT IN” clause have any unintended performance impact? e.g.

select * from table where userid not in IDSET(...)

@User ^^

This is not correct syntax. You should do

select ... where IN_ID_SET(userid, ...) = 0

Would be good to document this if not already documented. @User

thanks for the correction!