Thanks for the reply...

I am inserting data into temporary table so there is no question of indexes.