---
title: "Discussion on \"Multithreaded Execution Model for Queries With ORDER BY and LIMIT Clauses\" | Hashnode"
description: "Discussion on \"Multithreaded Execution Model for Queries With ORDER BY and LIMIT Clauses\". This small post continues the previous post dedicated to multithreaded query execution in databases with column-oriented storage format. This time we'll consider queries like the following:\nSELECT SearchPhrase\nFROM hits\nWHERE SearchPhrase IS NOT NULL..."
url: "https://hashnode.com/posts/multithreaded-execution-model-for-queries-with-order-by-and-limit-clauses/6665736b8d29735d83325c61"
---

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

Discussion

# [Multithreaded Execution Model for Queries With ORDER BY and LIMIT Clauses](https://puzpuzpuz.dev/multithreaded-execution-model-for-queries-with-order-by-and-limit-clauses?utm_source=hashnode&utm_medium=feed)

This small post continues the previous post dedicated to multithreaded query execution in databases with column-oriented storage format. This time we'll consider queries like the following: SELECT SearchPhrase FROM hits WHERE SearchPhrase IS NOT NULL...

Jun 9, 2024 · 2 min read · puzpuzpuz.dev  
Read the article

-   [#databases](https://hashnode.com/tag/databases)
-   [#multithreading](https://hashnode.com/tag/multithreading)

## Written by

[Andrei Pechkurov](https://hashnode.com/@puzpuzpuz)

@puzpuzpuz

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

Top data race and segfault producer in the room.

Core database engineer at QuestDB. Distributed systems gazer. Node.js contributor. Occasional tech blogger and speaker.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.