In most cases, querys are focused on the same shardkey, so implementing a cluster index on shardkey will be very friendly for query.

RocksDB can sort data by the key, so there can be a way to do this.

Thanks