profile advise

Hi All,

I have a long running  insert statement as  INSERT INTO table 1...i'm able run sta and i can apply its recommendation which makes it run better for its future execution..

The problem is process has multiple versions of insert statement and the statement differs only on the table name ie,table1,2..20 the rest of the statement is the same.these are temp tables.

It is really frustrating to run sta and assign profiles for each statement..is there a better way of managing this without profiles?

Thank you!