It's likely that we'd stay under a 100 rows 95% of the time. I've just been doing some side by side tests of a previous revision of the procedure and do not see the same recompile performance problem. the joins have changed quite a bit. I'm most curious now and will post results of my findings.