I've always had a problem with heap tables: The basic rule is don't do it. So you have to find something to use as a proper key. If the key is nondeterministic (like an address), then table inserts happen all over the place and pages get torn up. If you create your own primary key, then the table organization never relates to how the data is being used (similar records are not grouped). It's a problem as old as computing. The usual solution is a mix of brute force, blind ignorance, cunning and horsepower. Or programming as it's sometimes known.