What actions will prevent leveraging of the ResultSet cache?
What actions will prevent leveraging of the ResultSet cache?
Stopping the virtual warehouse that the query is running against will prevent leveraging of the ResultSet cache. This is because the virtual warehouse must be running and active to use the cache. Removing a column from the query SELECT list, the result not being reused within the last 12 hours, and executing the RESULTS_SCAN() table function do not directly prevent leveraging the ResultSet cache in the same way.
exactly maches previous query.
A is correct
Correct
A is correct
A & D both are correct
Only A, sorry. D will force the use of Result Cache.
A & D both are correct