A query is consuming more credits than anticipated. The Query Profile indicates that the majority of the query execution time is spent on remote disk I/O.

How can this be mitigated in the future?