• Well, this is why I don't post a whole lot, I sometimes type without thinking! You CANNOT execute any DDL for the table var outside of its declaration, therefore you CANNOT create indexes. Inline constraints are the only option for table var's. If you do need indexes, temp tables may be a better option.

    One other way table vars can increase performance is that they tend to trigger fewer recompiles in your sp's...