| When you compare Table Variable and Temporary Table which one faster?
When we compare both of these Table variable functions faster than a temporary table and reason behind is that Table variable are mainly stored in memmory, But when we ask about the temporary tables these are mainly stored in a disk. And we can also say when Table variable size exceeds the size of memory speed will also be decreases. | | |