Post reply

Killing non-clustered index creation

  • May 19, 2017 at 10:16 am

    #330366

    Hi All,

    I just ran a CREATE NON-CLUSTERED INDEX statement against a 10 TB table. It is running for last 3 hours.  What happens if i KILL it? Will it roll back?

  • May 19, 2017 at 11:27 am

    #1943367

    It will. It might take as long or longer to rollback.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • May 22, 2017 at 7:35 am

    #1943556

    karthik.catchme - Friday, May 19, 2017 10:16 AM

    Hi All,

    I just ran a CREATE NON-CLUSTERED INDEX statement against a 10 TB table. It is running for last 3 hours.  What happens if i KILL it? Will it roll back?

    You are not creating on whole columns right,only on specific column i believe. As Grant mention it will rollback and might take longer time .

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply