What the difference between rebuild index and re-organize index?

avg_fragmentation_in_percent value

Corrective statement

> 5% and < = 30%

ALTER INDEX REORGANIZE

> 30%

ALTER INDEX REBUILD WITH (ONLINE = ON)*

* Rebuilding an index can be executed online or offline. Reorganizing an index is always executed online. To achieve availability similar to the reorganize option, you should rebuild indexes online.

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/mfrbuaa/p/3962178.html