How do subresult reuse and result caching improve query speed in Firebolt?

“Firebolt's FireCache spans three layers: a full result cache that serves repeated queries directly, a join hash table cache that reuses hash tables computed during previous requests, and a pagination input cache. Together they let Firebolt reuse intermediate query artifacts when serving new requests, reducing query processing times significantly while maintaining real-time, fully transactional results.”