Hi,
in short:
- TableVariables don't change the schema, but are also executed in tempdb
- TempTables have statistics in comparison to TableVariables (query fast, costs after change)
I personally use TableVariables more often than TempTables, because I can't forget to drop them :-)
long version:
kind regards,
Daniel
in short:
- TableVariables don't change the schema, but are also executed in tempdb
- TempTables have statistics in comparison to TableVariables (query fast, costs after change)
I personally use TableVariables more often than TempTables, because I can't forget to drop them :-)
long version:
kind regards,
Daniel
No comments:
Post a Comment