This is exactly one of the best reasons, frankly, for moving to using views rather than tables. I don't mean it as flippantly as it may sound.


>For those that advocate using surrogate foreign keys (non-business key) I have a question. How do you best handle sorting on a foreign key?
...snip