speeding up updates and insert

I have to update table a and insert new records in table a based on records in table b.

Are there any methods for speeding this up other than direct path? Received on Mon Apr 22 2002 - 12:58:29 CDT