Hi,

I have 1 table which has about 20 records...and I need to update another table which has 10 million records using column data from the small table.

eg:

table A(small table)

Column A Column B
312 412

table B(large table)

Column C
312456
312789

I need to update this table B, column C such that the updated values would be

412456
412789

So we would have to use functions (substring) in the update statement.

What would be the best approach for this?

Would function based index help? Is there a better way than using function based index?

Thanks
Sam