Attaching tables on read-only disks optimizes resource usage

Attaching tables on read-only disks will use fewer resources by not loading outdated parts. #65635 (Alexey Milovidov).