Temp Table Indexs 1

[DotNetBlocks]

Is it possible to add an index to a temp table?

Here is my query:

select id, name from #tmpNetworks where id = 28
and netplan=33

I would like to put an index on id and netplan.

Thanks

 

[SQLDenis]

create index ixtmp_Netplan on #tmpNetworks(netplan)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[DotNetBlocks]

Thanks