prewarm_index() on a table —
an idempotent hint that loads a built index into memory ahead of a query.
Why it matters
Without prewarming, a fresh or restarted executor would fill its indexes lazily, so the first queries it serves pay the cost of loading and deserializing them from object storage. Holding the executor out of the fleet until its configured tables are warm means every query it ever serves gets a warm cache, so performance stays consistent through restarts and rollouts instead of dipping right after each one. Contact us to learn more about how prewarming is configured for your deployment.What to read next
Data Page Cache
The raw-data-page cache — a separate cache from the one prewarm fills.
Tiered Index Cache
The deserialized-index cache prewarm fills.
Architecture
Where plan executors and query nodes sit in the serving fleet.