How can I construct a SOQL query for updating multiple records efficiently?

In the context of Salesforce, here is the approach given of how you can construct a SOQL query by using the “UPDATE” keyword for updating multiple records efficiently:-

Suppose you need to update the “status” field of all accounts owned by a particular sales rep (OwnerID = 005XXXXXXXXXXXX) for “active” by using the SOQL query for performing this update efficiently and accurately:-

Then here is the solution given below:-

UPDATE Account

SET Status__c = ‘Active’
WHERE OwnerId = ‘005XXXXXXXXXXXX’
Here is another example given:-
// Define a class to handle the update operation
Public class AccountUpdater {
    // Method to update Account records owned by a specific Sales Rep
    Public static void updateAccountsForSalesRep(String salesRepId) {
        // Query for Accounts owned by the specified Sales Rep
        List accountsToUpdate = [SELECT Id, Status__c FROM Account WHERE OwnerId = alesRepId];
        // Check if there are any records to update
        If (!accountsToUpdate.isEmpty()) {
            // Iterate through each Account record and set the Status__c field to ‘Active’
            For (Account acc : accountsToUpdate) {
                Acc.Status__c = ‘Active’;
            }
            // Perform the update using DML (Data Manipulation Language)
            Try {
                Update accountsToUpdate;
                System.debug(‘Accounts updated successfully’);
            } catch (Exception e) {
                System.debug(‘Error updating accounts: ‘ + e.getMessage());
            }
        } else {
            System.debug(‘No accounts found for the specified Sales Rep’);
        }
    }
    // Example usage in a test method or elsewhere
    Public static void main(String[] args) {
        // Provide the Sales Rep Id for whom you want to update accounts
        String salesRepId = ‘005XXXXXXXXXXXX’;
        // Call the update method
        updateAccountsForSalesRep(salesRepId);
    }
}