Join with a global temp table

I want to join a global temp table (delete on commit, not more than 250.000 records) with a normal table (about 100 mio records).

To speed up the join - would it be better to create a primary key on the join column of the temp table?

My tests show that it seems not to affect the join performance - but my test system has only 200.000 records in the normal table.

I'm asking because the PK on the temp table slows down the inserts to the temp table quite much (factor 2 - 3).

Thank you Received on Sun Mar 01 2009 - 11:19:53 CST