View the original community article here
Last tested: Jun 11, 2019
Results in Table
When downloading the same number of rows as the Explore the download query will run against the Explore cache until the cached results are invalidated.
When downloading a different number of rows than are returned in the Explore the SQL query is changed, so the download will run against the database.
What about subsequent downloads?
This is still unclear. Most testing seems to suggest that download queries are not stored in cache, however there have been user reports of stale data being returned in downloads with the same row limit as previous exports so the answer to this may be circumstantial.