guarddata, Why not a clustered index? Purly because of the work SQL will have to do during inserts / deletes?
If the table does not that busy with inserts and deletes would a clustered index not be better assuming you are going to use that column on joins?
Just curious. 🙂
Cheers,
Crispin
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!