---
title: "Discussion on \"Inside the Query Optimizer: How Databases choose and Evaluate Query Plans\" | Hashnode"
description: "Discussion on \"Inside the Query Optimizer: How Databases choose and Evaluate Query Plans\". You write a query.\nThe database runs it.\nYou get your result.\nSimple, right?\nNot quite.\nBefore your query ever runs, the database is already making decisions behind the scenes. It evaluates different"
url: "https://hashnode.com/posts/inside-the-query-optimizer-how-databases-choose-and-evaluate-query-plans/69f9d77da386d7f1217d7039"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Inside the Query Optimizer: How Databases choose and Evaluate Query Plans](https://violacordis.hashnode.dev/inside-the-query-optimizer-how-databases-choose-and-evaluate-query-plans?utm_source=hashnode&utm_medium=feed)

You write a query. The database runs it. You get your result. Simple, right? Not quite. Before your query ever runs, the database is already making decisions behind the scenes. It evaluates different

May 5 · 7 min read · violacordis.hashnode.dev  
Read the article

-   [#query-optimization](https://hashnode.com/tag/query-optimization)
-   [#databases](https://hashnode.com/tag/databases)
-   [#backend](https://hashnode.com/tag/backend)
-   [#data](https://hashnode.com/tag/data)

## Written by

[Ikem Ada](https://hashnode.com/@Violacordis)

@Violacordis · Nigeria

  
[View profile](https://hashnode.com/@Violacordis)

Software Engineer

I am a Software Developer from Lagos, Nigeria.

## Responses 1

Markdown supported · ⌘↵ to post

[Dante Brekke](https://hashnode.com/@sparkleracidic)

[Oct 28](https://hashnode.com/posts/inside-the-query-optimizer-how-databases-choose-and-evaluate-query-plans/69f9d77da386d7f1217d7039/comment/6ae1a25240eb03c844400fde)

What a great post on query optimization! I never knew how much a database takes into account when it decides how to evaluate query strategies. I wonder if these optimizers will behave differently in the future [scratch online](https://scratchgamesonline.io/) as the AI improves.
