prefetching facilities to reduce query time