Question: what is difference between rebuild index and reorganize in sql server?
Answer: REORGANIZE is a pure cleanup operation which leaves all system state as is. There are a number of differences. Basically, rebuilding is a total rebuild of an index - it will build a new index, then drop the existing one, whereas reorganising it will simply, well... it will reorganise it.