Sorry, no other ideas apart from normalising of co...

# exposed

[andrewoma]

Sorry, no other ideas apart from normalising of course. I've never really hit the situation where indexing on a small set of codes is critical - if the set of codes is small and the table is large, it's not going to be a great index anyway.