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);

    }

}