Temp table cache 5

~ S

Conclusions:

  • DROP statement vs no DROP statement = no changes , all are cached
  • altering table vs creating DDL from start = here it’s a difference.  no cached / yes cached
  • adding index vs DDL statement with inline index – no cached / yes , cached.

 

For more info , visit  this and this.

 

S

 

Unknown's avatar

Published by S

fan of t-sql some years experience with sql server

Leave a comment