3 ms·Proper solution (not fake with triggers) should be at most as costly as having partial index on the table.by scotty79 15y agoProper solution (not fake with triggers) should be at most as costly as having partial index on the table.