---
title: "Discussion on \"Why does an apparently simple optimization often become a system’s first real architectural decision?\" | Hashnode"
description: "Discussion on \"Why does an apparently simple optimization often become a system’s first real architectural decision?\". Explore how database indexes represent one of the first architectural tradeoffs by prioritizing query performance over modification cost."
url: "https://hashnode.com/posts/why-does-an-apparently-simple-optimization-often-become-a-system-s-first-real-architectural-decision/6a557112510e981867bdc94d"
---

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

Discussion

# [Why does an apparently simple optimization often become a system’s first real architectural decision?](https://evankhandev.hashnode.dev/why-does-an-apparently-simple-optimization-often-become-a-system-s-first-real-architectural-decision?utm_source=hashnode&utm_medium=feed)

Explore how database indexes represent one of the first architectural tradeoffs by prioritizing query performance over modification cost.

Jul 13 · 2 min read · evankhandev.hashnode.dev  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#database-design](https://hashnode.com/tag/database-design)
-   [#software-architecture](https://hashnode.com/tag/software-architecture)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#systems-engineering](https://hashnode.com/tag/systems-engineering)

## Written by

[Sergio González Téllez](https://hashnode.com/@evandev)

@evandev · Mexico City, Mexico

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

AI Engineering | ML Systems | MLOps | Building Reliable AI Architectures

## Responses

Markdown supported · ⌘↵ to post

No responses yet.