curious_sqldba (11/12/2013)
GilaMonster (11/12/2013)
Nope. Not unless your bulk load is querying the table first. Stats do not get created or updated unless they are needed to generate an execution plan.So bulk inserts don't need a execution plan? i thought every query needs it
Sure it needs an execution plan, I didn't say they don't use a plan. What I said was 'unless [the stats] are needed to generate a plan'. Statistics are needed when the row distribution of the existing data in the table affects the choice of execution plan. Insert plans don't change based on the data that's already in the table.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability