Join between two @table variables

[quote user="atulgoswami"]
What is the difference between in below two scenarios (from performance point of view)?
(1) Join between two @table variables
And
(2) Join between @table variable and #temp table
Thanks
Aero
[/quote]
Performance problem occurs if there are no indices and too much data on the tables

Additionally table variables are limited in the type of constraints available to them. And also no statistics are kept for them.

[quote user="atulgoswami"]
[quote user="FrankKalis"]
Additionally table variables are limited in the type of constraints available to them. And also no statistics are kept for them.
[/quote]
My question was on different lines. What is the advantage if join one #temp table and @table variable OVER between two @table variable.
I was in discussion and there somebody said that Joining one #temp table and @table variable has performance advantage OVER join between two @table variable. Howevere i could not think of any reason behind this.
[/quote]
There is no advantage of one method over the other. A JOIN operation is a JOIN operation. However, temporary tables and table variables serve different purposes and should be used differently. Here is a good starting point: http://blogs.msdn.com/sqlserverstor...-table-variable-vs-local-temporary-table.aspx

Small addition: However, as I mentioned before because of the limited possibility to define indices on table variables it might hurt performance when you JOIN to a table variable on non-key column(s).