Example of current searchClientsByAttributes in main, for a particular client attribute value, providing increasing offset values.
explain analyze select ce1_0.ID
from CLIENT ce1_0
join CLIENT_ATTRIBUTES a1_0
on ce1_0.ID=a1_0.CLIENT_ID
where ce1_0.REALM_ID='redacted'
and a1_0.NAME='redacted'
and substr(a1_0.VALUE,1,255)=substr('true',1,255)