• Regarding 3) about rebuilding non clustered indexes based on the fragmentation of the clustered index. Is this a best practice? The stored procedure does not support this.

    Ola :- If clustered index need to be rebuild then don't we need to rebuild all non-clusted index on same table... I am not sure but i think rebuilding clustered index will not rebuild non-clustered automatically..