[Bug]: the performance of partition keys is far inferior to scalar retrieval

[Bug]: the performance of partition keys is far inferior to scalar retrieval #155496