---
title: "What are indexes fragmentation and statistics? How do you maintain them?"  
description: "What are indexes fragmentation and statistics? How do you maintain them?"  
author: "Anubhav Sharma"  
published: 2026-05-14  
updated: 2026-05-14  
canonical: https://answers.mindstick.com/qa/116613/what-are-indexes-fragmentation-and-statistics-how-do-you-maintain-them  
category: "database"  
tags: ["database", "sql server"]  

---

# What are indexes fragmentation and statistics? How do you maintain them?


---

Original Source: https://answers.mindstick.com/qa/116613/what-are-indexes-fragmentation-and-statistics-how-do-you-maintain-them

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.