---
title: "Comment by Abdelrahman Kefafy on \"High Performance MySQL [Ch.5: Indexing for High Performance]\" | Hashnode"
description: "Match a leftmost prefix is quite not clear. Could you please explain it in a more clear way?"
url: "https://hashnode.com/posts/high-performance-mysql-ch5-indexing-for-high-performance/607ad6f3c99e200d08f7ae37/comment/664fb7c62c0b864bf373ceb5"
---

[Discussion](https://hashnode.com/posts/high-performance-mysql-ch5-indexing-for-high-performance/607ad6f3c99e200d08f7ae37)

Comment [High Performance MySQL \[Ch.5: Indexing for High Performance\]](https://hashnode.com/posts/high-performance-mysql-ch5-indexing-for-high-performance/607ad6f3c99e200d08f7ae37)

[Abdelrahman Kefafy](https://hashnode.com/@abdelrahmanayyman)

[May 23, 2024](https://hashnode.com/posts/high-performance-mysql-ch5-indexing-for-high-performance/607ad6f3c99e200d08f7ae37/comment/664fb7c62c0b864bf373ceb5)

Match a leftmost prefix is quite not clear. Could you please explain it in a more clear way?

[Sayed Alesawy](https://hashnode.com/@sayedalesawy)

[May 23, 2024](https://hashnode.com/posts/high-performance-mysql-ch5-indexing-for-high-performance/607ad6f3c99e200d08f7ae37/comment/664fb7c62c0b864bf373ceb5#reply-664fbb68bf41a07a8f25ba14)

If we have a composite index like this idx(a,b,c). A leftmost prefix is a or ab or abc and so on. Any query pattern than can be covered by a leftmost prefix of the index can in fact utility this index. Is that more clear?
