Tuning Guide for Larger-than-memory Queries #16177

Is your feature request related to a problem or challenge?

It would be great to include an example (under datafusion-examples) to illustrate:

1. Show how to configure the DataFusion runtime so that a query can run within a specified memory limit.

2. Provide example queries and walk through interpreting the EXPLAIN output, focusing on understanding memory usage and identifying whether and when spilling happens.

3. Describe the relevant configuration options for larger-than-memory queries.

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response