Thanks for replying.

Yeah that's what I'm getting at I'm essentially moving all one shop's data to another shop.

The PK will still be there but I thought about using the disable index for all other indices that have shopid in it.

(Odd table but clustered index is not the PK but the clustered index is on the datetime of sale its a warehouse type/reporting table so insert time not a concern)

I've not used disable before but read somewhere that it doesn't use the disk space up that a drop and recreate does.