Dear Gurus,
Can you please tell me, Indexing a Temporary table will help in improving the performance of a query where the table is being used ?
Say i have a Temp table where i am staging records for some calculations ( there are more than 0.1 million rows in every run ) , since data is getting inserted during the execution , having indexes on the table will give me any performance benefits?
Please suggest.