• Yes it may slow down the performance, as it uses parallel sessions to execute the DBCC.

    So execute it after peak hours. It took 5 mins in my system for the big table.

    DBCC SHOWCONTIG (tablename)