GilaMonster (1/16/2010)
3) The only indexes that can be created against table variables are primary key and unique constraints (and even then, people don't usually bother)It's not a problem with 10 rows in the temp table (but then neither's the lack of stats). ...
Gail did you mean table variable here?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events