If the temp table is ultimately selected from, you could alternatively create a specific reporting table which is not temporary and apply suitable indices there.

This offers the added benefit of...