Join between multiple Shard
I might miss this out when skimming tru the docs. How do we run query (join) accross multiple shard? if I had few tables in the join that is sharded and they are shard base on different columns, how will the performance like? any best practices or things to avoids?