At Cockroach Labs our Cost-Based Optimizer takes into account the location of the data and delivers better plans & better ways to execute your queries.