Sql server ReIndex Or ReOrganize
What is the difference between Index REBUILD and REORGANIZE and when exactly should you use it Couple of days ago, there was an interesting statement (or rather a question) that was brought up by one of the colleagues in the company. Ultimately, the initial statement left us with one simple question, which is the difference between Index REBUILD and REORGANIZE and when should you be exactly using it. If you Google the aforementioned, you can find numerous posts/blogs regarding this. Therefore, I will keep things very simple and easier way to understand. Rebuilding an index or reorganizing is required when index fragmentation has reached a considerable percentage. The fragmentation percentage can be identified using the Dynamic Management View - sys.dm_db_index_physical_stats in SQL Server. You may get more details on the view at the following link: https://msdn.microsoft.com/en-us/library/ms188917.aspx . You can get a list of fragmented indexes using the following quer