That page doesn't mention how joins between tables using different split keys work, or how indexes work.