# Reducing query load from filters and sheets

*Tableau Consultant Study Guide · Design and Troubleshoot Calculations and Workbooks · Last updated November 3, 2026 · https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/reducing-query-load-from-filters-and-sheets*

Find the filters and sheet designs that multiply queries, then cut them: filter actions instead of Only Relevant Values cards, summary fields and ranges instead of long item lists, extract and data source filters instead of context filters, one level of detail for query batching, Show Apply Button, narrow filter scope and paused updates while authoring.

- Certification: Salesforce Tableau Consultant
- Exam section: Design and Troubleshoot Calculations and Workbooks
- Study guide: https://www.certifyforce.com/study-guide/tableau-consultant

**Official exam objective:**

> Identify and resolve resource-intensive queries.

## What the exam expects

- Recognize the filter settings that send extra queries (Only Relevant Values, long Keep Only or Exclude lists, filters shared across many worksheets, cross-database filters) and recommend the lighter design.
- Explain why context filters are an order-of-operations tool, not a query accelerator, and recommend extract and data source filters to limit data instead.
- Recommend a shared level of detail across dashboard sheets so Tableau can batch queries, and fewer sheets and filter cards overall.
- Use Show Apply Button, worksheet scope and paused automatic updates to stop a query after every click.

Key terms:
- **Only Relevant Values:** a filter card option that shows only values passing the other filters, which needs a query whenever those filters change.
- **Context filter:** an independent filter computed first; other filters become dependent filters that process only data passing it.
- **Query batching:** Tableau combining queries from sheets built at the same level of detail.
- **Show Apply Button:** a filter card option that applies changes only when the user clicks Apply.

## Key facts

| Fact | Detail | Source |
|---|---|---|
| Filter card cost | Each interactive filter needs a query to populate its options | [Make Visualizations Faster](https://help.tableau.com/current/pro/desktop/en-us/perf_visualization.htm) |
| Only Relevant Values | Creates a query each time the other filters change | [Performance Checklist](https://help.tableau.com/current/pro/desktop/en-us/perf_checklist.htm) |
| Context filters today | Force an order of operations; no longer help query performance | [Performance Checklist](https://help.tableau.com/current/pro/desktop/en-us/perf_checklist.htm) |
| Many context filters | One context filter that greatly reduces data beats many | [Use Context Filters](https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm) |
| Context and referential integrity | Context filters can hurt Assume Referential Integrity gains | [Use Context Filters](https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm) |
| Query batching | Same level of detail on multiple dashboard sheets | [Performance Checklist](https://help.tableau.com/current/pro/desktop/en-us/perf_checklist.htm) |
| Show Apply Button | Multiple values lists and dropdowns only; available in web authoring | [Filter Data from Your Views](https://help.tableau.com/current/pro/desktop/en-us/filtering.htm) |
| New filter scope | Current worksheet only, by default | [Apply Filters to Multiple Worksheets](https://help.tableau.com/current/pro/desktop/en-us/filtering_global.htm) |
| Publishing | Does not improve performance; tune in Desktop first | [Performance Checklist](https://help.tableau.com/current/pro/desktop/en-us/perf_checklist.htm) |

## Check yourself

- Why can a dashboard with many filter cards render slowly even before anyone clicks?
- When does changing a data model setting force a context filter to recompute?
- When a filter is set to All Using This Data Source, which new worksheets receive it?
- Why does zooming into a dense view not reduce the marks Tableau must handle?

## Sources

- [Tableau Workbook Performance Checklist](https://help.tableau.com/current/pro/desktop/en-us/perf_checklist.htm)
- [Make Visualizations Faster](https://help.tableau.com/current/pro/desktop/en-us/perf_visualization.htm)
- [Use Context Filters](https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm)
- [Turn off Automatic Updates to Boost Performance](https://help.tableau.com/current/pro/desktop/en-us/queries_autoupdates.htm)
- [Design for Performance While You Build a View](https://help.tableau.com/current/pro/desktop/en-us/perf_build_view.htm)
- [Filter Data from Your Views](https://help.tableau.com/current/pro/desktop/en-us/filtering.htm)
- [Apply Filters to Multiple Worksheets](https://help.tableau.com/current/pro/desktop/en-us/filtering_global.htm)
- [Filter Actions](https://help.tableau.com/current/pro/desktop/en-us/actions_filter.htm)
- [Test Your Data and Use Extracts](https://help.tableau.com/current/pro/desktop/en-us/perf_extracts.htm)
- [Record and Analyze Workbook Performance](https://help.tableau.com/current/pro/desktop/en-us/perf_record_create_desktop.htm)
- [Optimize Workbook Performance](https://help.tableau.com/current/pro/desktop/en-us/performance_tips.htm)

## About the full unit

The "Core concepts", "Exam traps" and "Worked scenario" sections of this unit, its 6 linked practice questions, and unlimited timed mock exams are included with the Tableau Consultant pack (USD $19): https://www.certifyforce.com/practice-exams