What do you meant exactly that it would be a heavier hit to do the scans?? It's somewhat heavier, but you're talking about a few % on the whole process... but you may save 30-40% on that transaction. I'm not sure how possible that is to do in your case, I would need to see the trigger code to be able to answer that one.