table varialbe:
- has some limitation compared to temp table
- has less recompilation
- not good choice for large data (row number is always 1 and no stats is available)
- can be used with DMV tables
- etc
Tuesday, 14 August 2012
temp table vs table varialbe
(http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html)
table varialbe:
table varialbe:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment