---
title: "Comment by Mohab Yaser on \"High Performance MySQL [Ch.5: Indexing for High Performance]\" | Hashnode"
description: "In the clustered indexes section, in the second paragraph, you said that that clustered means that the \"whole table\" is stored in the index leaf nodes, while in"
url: "https://hashnode.com/posts/high-performance-mysql-ch5-indexing-for-high-performance/607ad6f3c99e200d08f7ae37/comment/66859a8e3ca78ff712784e4d"
---

[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)

[Mohab Yaser](https://hashnode.com/@mohabyaser0)

[Jul 3, 2024](https://hashnode.com/posts/high-performance-mysql-ch5-indexing-for-high-performance/607ad6f3c99e200d08f7ae37/comment/66859a8e3ca78ff712784e4d)

In the clustered indexes section, in the second paragraph, you said that that clustered means that the "whole table" is stored in the index leaf nodes, while in the third paragraph you said that the leaf nodes in the clustered index contain the entire "row", so which of them is true? Or you intended to say in the third paragraph that the leaf nodes have the row itself not a pointer to its position in disk?

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

[Jul 3, 2024](https://hashnode.com/posts/high-performance-mysql-ch5-indexing-for-high-performance/607ad6f3c99e200d08f7ae37/comment/66859a8e3ca78ff712784e4d#reply-6685cdc1abe2bd758732dddd)

I don’t see how they are contradicting? The entire table is in the clustered index and it’s stored as one row per leaf. Both statements are correct. And yes, for an innodb engine, there are no disk pointers.

Did that answer your concern?

[Mohab Yaser](https://hashnode.com/@mohabyaser0)

[Jul 7, 2024](https://hashnode.com/posts/high-performance-mysql-ch5-indexing-for-high-performance/607ad6f3c99e200d08f7ae37/comment/66859a8e3ca78ff712784e4d#reply-668ad4daf44da8ee45001a06)

Yeah, thank you.
