There is also the question whether you are populating the entire table with
an INSERT INTO statement or SELECT INTO.
The latter will be much faster with many rows since it bypasses logging.
If your circumstances allow you to populate most or all of the temp table
with a large number of rows via SELECT INTO before building the index, this
may tip the balance. Would be worth testing.
> I am using temporary table in my stored procedure.
> For improving performance, i have created Index.
> Is there is any difference between "Creating Index Before
> inserting data" and "Creating Index after inserting data"?
> If so, Which method of creation will improve performance?
> Any help?