# Set up query pushdown parameter optimization

To set up this optimization, complete these steps:

1. **Open the Data Service window**, then click the **Query Pushdown** tab.
2. Click the Plus Sign button near the **Parameters** label.
3. In the Create Parameter window add the name of an optimization parameter you created in the input step’s SQL query.
4. Click **OK**.
5. Select the step that contains the parameter from **Step Name**.
6. In the **Definitions** area of the window, enter the **Data Service Field** and the **Step Field** you want to parameterize.
   * The **Data Service Field** contains the transformation's name of the field you want to parameterize. The name should be as it appears in the transformation's output field. For example, you might have renamed the `cty` field from your data source to `country`. You would enter `country` in the **Data Service Field**.
   * The **Step Field** should contain the data source's name of the field you want to parameterize. For example, if you wanted to parameterize the `cty` field in a MySQL database, enter `cty` in the **Step Field**.
7. Optionally, you can click the **Get Optimizations** button to automatically generate input step optimizations based on the output fields for the step on which you have created the data service and input fields.
8. Click the **OK** button to save and close the window.
9. **Test the optimization**.
10. **Publish the Pentaho Data Service**.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.pentaho.com/pdia-data-integration/archived-merged-pages/pentaho-data-services-archive/optimize-a-pentaho-data-service/apply-a-query-pushdown-optimization/set-up-query-pushdown-parameter-optimization.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.