Watch this video on YouTube
Scenario Two users run the identical SQL text but only the first hits the result cache; the second query still scans data. Both are in the same warehouse.