I have a table that get's built on a nightly basis and it is utilized for reporting purpose. It appears some of the reports' T-SQL statements are joined with the temp table and production table in order to retain data. For example, the temp table is called Stval and contain a column called CustID. The production table is called ValMet and contains CustID column. Therefore, T-SQL statement are being join by StVal and ValMet. My question is, If I were to create an index on the temp table, would I expect performance gain?