Update

[Mala232]

Hello all

I have a question
there's a table which contains 5 millions of records and I want to update 1 million records. so what should be my primary concerns.

like you did some changes for the performance reason...

Please any boby reply this
Regards
Mala

[debasisdas]

what if it contains 5 million records.

update as you do usually,.

[Mala232]

what if it contains 5 million records.

update as you do usually,.

hello,
My question is a table already contains 5 million and need to update 1 million only during this process if performance should to good what situations /conditions you take into considerations.

[debasisdas]

There sould be index on the column on which the WHERE condition of the update statment is based.
Ensure that there is nolocks on the table.
The table is not being used by other users for any other purpose like any select.

[Mala232]

Thank you Debasis for your reply