Oracle Exadata System Software evaluates the predicate in a DML statement to determine the rows of interest. These rows are sent back from the storage servers to the database servers, which then uses the ROWIDs to update the rows. This feature expands this functionality to return ROWIDs for data stored in columnar compression format.

For example, consider the following SQL query:

UPDATE weather_history SET temp = (temp – 32) * (5/9)
WHERE country = 'ENGLAND'

Smart scan is used to find the rows that satisfy country = 'ENGLAND' using ROWID values returned from a previous phase of the command processing.

This feature can improve the performance of DML statements by up to 5x.

Minimum requirements:

• Oracle Exadata System Software release 19.3.0
• Oracle Database release 18.3.0.0.180717DBRU