[Swannie]

This is: "Split the index in your application code."

And then do your joins, in your application code.