Rebuilding an index drops and re-creates the index. This removes fragmentation, reclaims disk space by compacting the pages based on the existing fill factor setting, and reorders the index rows in contiguous pages. [Source technet.microsoft.com] Note – If tables are small then rebuilding index will be fast and there won’t be any