---
title: "Discussion on \"Why index rebuild does not reduce index fragmentation\" | Hashnode"
description: "Discussion on \"Why index rebuild does not reduce index fragmentation\". There may be 2 reasons for this. The first is that the index is less than 8 pages, and the second is that there is not enough space on the hard disk to rebuild.\nLess than 8 pages\nIf an index is very small (less than 8 pages) it will use mixed extents..."
url: "https://hashnode.com/posts/why-index-rebuild-does-not-reduce-index-fragmentatation/657eac4c95968496c07acfc7"
---

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

Discussion

# [Why index rebuild does not reduce index fragmentation](https://karatas.dev/why-index-rebuild-does-not-reduce-index-fragmentatation?utm_source=hashnode&utm_medium=feed)

There may be 2 reasons for this. The first is that the index is less than 8 pages, and the second is that there is not enough space on the hard disk to rebuild. Less than 8 pages If an index is very small (less than 8 pages) it will use mixed extents...

Dec 17, 2023 · 1 min read · karatas.dev  
Updated Sep 4, 2024  
Read the article

-   [#indexing](https://hashnode.com/tag/indexing)
-   [#sql-server](https://hashnode.com/tag/sql-server)
-   [#fragmentation](https://hashnode.com/tag/fragmentation)

## Written by

[Ferhat Karataş](https://hashnode.com/@karatas)

@karatas · Turkey

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

Software Developer

Performance freak

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
