Thanks for that - very useful information!

Just to clarify - my question is more about how long the ALTER INDEX REORGANIZE command itself will take to run, rather than if there is an improvement in the...

Thank you very much for your response.

So does this mean that given the same RAM + CPU + Disks, an index with more pages but say 10% fragmented, should...