Recursive Select - What is this really doing

  • I've noticed several instances of what looks like a recursive insert with the format:

    insert [dbo].[MyTable] select * from [dbo].[MyTable]

    I've been able to show that it isn't in fact inserting rows reclusively, but the most likely thing it seems to be associated with is a Create Clustered Index operation. Unfortunately I can't correlate every incident of this back to an index create statement.

    Does anyone know what SQL is doing here and why?

    • This topic was modified 2 hours, 40 minutes ago by Leo.Miller.

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

Viewing post 1 (of 1 total)

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