SSC has a massively important point. If you have a clustered index that isn't naturally sequenced in the same way that values the field arrive at the database then...
I'm pretty new to this level of analysis (hence the question). But the question comes from my work with triggers where an Update gives you access to the deleted and...