Tim

I don't know if this is already in your heap but if not would it be possible to handle things such as

WHERE
_ID IN (SELECT _fkID FROM FilterResults WHERE _fkFilters = 35)

In a more intelligent fashion? It takes a lot longer (c9 secs) than if I construct the list myself using
SELECT LIST(CAST(_fkID AS VARCHAR),',') FROM FilterResults WHERE _fkFilters = 35

and stuff the answer into the query as

WHERE
_ID IN (31111,31119,33058,35404,36018,39319,44579,46657,46658,49735,55062)


Roy Lambert