Therefore, from the point of view of the performances temporary table and table variable are similar.
Thanks
Not always. It depends on the data, and the choice of optimizer. As a case, Parallelism will not support with table variable, but qualifies the temp table. Likewise, other factors. Please read the link posted in the previous thread.
Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
No comments:
Post a Comment