Chapter 2: Using showplan
FROM cache message
This message shows that a
CACHE SCAN
operator is reading a single-row in-memory table.