ScottPletcher (10/3/2012)
Typically customer codes are sequential. Since they're not here, that would definitely make the clustering key choice much more difficult.
Typically customer codes occur in order records more often than in customer records, and while they may be sequential in order of creation of customers they are certainly not sequential in terms of creation of orders. So the ideathat a customer code is typically sequential in relation to whatever table we are talking about here is not reasonable.
Tom