Session switch for lazy loading

is there is any way to switch a session for lazy loading data, I have a multi shards DB env,
the joined data saved on another db instance