• Depends on new index size and DB will grow

    User DB will never return it to OS automatically and tempdb will not return it till the next SQL restart.

    Regards
    Durai Nagarajan