[Opt](multi-catalog)Improve performance by introducing cache of list directory files when getting split for each query.

[Opt](multi-catalog)Improve performance by introducing cache of list directory files when getting split for each query. #85697