When you select count(*) from the remote table you're probably getting a fast index-based access method. Check the execution plan for the local MV, as it sounds like you're getting a full table scan