Thanks! The merge join issue seems like one that probably would affect many workloads. Ordering by key less so but good to realize. I guess it would be helpful

Thanks! The merge join issue seems like one that probably would affect many workloads. Ordering by key less so but good to realize. I guess it would be helpful for this feature to also include some documentation about if/when to use hash indexes, since up to this point the db has issued a warning basically saying "don't use these." Right now I'd imagine that there will be a lot of confusion around it given the feature's history so people will just not consider it.