why do they need to scan records if $nin or $ne contains only one value.
for eg: user | ispayed 1 | Y 2 | N
if i ask ispayed != 'Y', they still can scan the index and come to a decision right?