Statistics creation showing in query text with temp table inserts
Has anyone else ever seen statistics getting created as part of the query text, when inserting to temp tables? I've never seen it before and can't find another instance of it happening. There are no custom stats being created as part of the query.
... FROM [dbo].[tbl_email_metadata] ...
Plan Explorer shows these operations because you triggered them (Management Studio will not, nor would Plan Explorer if you generated this plan in SSMS or pulled it from the plan cache).