Cut down Updation time 4 Updating 3 Lacs row's 10 columns with diff.-2 functions

Dear All,

We have 3,00,000 rows in a table. This table has a Primary Key named In_Id.

To update this table 10 columns, we have separate-separate 10 scalar functions with different-different definitions. In these functions we have to pass Primary Key of this table & get the output. It works fine when we work with small-small bunch of rows. But, when we try to update these 10 columns for all 3,00,000 rows then it takes 45-60 minutes to update the table.

The frequency of updating these 3,00,000 rows is depends on user requirement, means as & when user generates the report then before showing the results this updation process needs to execute.

How do we cut down this time?

follow this advice