---
metadata:
  - name: generator
    content: Diplodoc Platform v5.64.0
alternate:
  - https://ydb.tech/docs/en/dev/optimization/index.md?version=v26.2
  - https://ydb.tech/docs/ru/dev/optimization/index.md?version=v26.2
  - href: https://ydb.tech/docs/en/dev/optimization/index.md?version=v26.2
    type: text/markdown
    title: Markdown version
  - href: https://ydb.tech/docs/en/llms.txt?revision=baf4f440c2d19fde153ad4482822c048b4391354&version=v26.2
    rel: describedby
sourcePath: en/core/dev/optimization/index.md
---
> **Documentation Index:** Fetch the complete configuration index at https://ydb.tech/docs/en/llms.txt?revision=baf4f440c2d19fde153ad4482822c048b4391354&version=v26.2

# Query execution optimization

Materials on analyzing and tuning query execution:

- [Using query plans for query optimization](https://ydb.tech/docs/en/dev/optimization/plans.md?version=v26.2) — logical and execution plans, finding bottlenecks.
- [Optimizer hints](https://ydb.tech/docs/en/dev/optimization/hints.md?version=v26.2) — influencing the cost-based optimizer via the `PRAGMA ydb.OptimizerHints` pragma.
- [Parameterized queries and recompilation](https://ydb.tech/docs/en/dev/optimization/parameterized-queries.md?version=v26.2).