Resolution:
A macro consists of one or more SQL statements that can be executed by performing a single statement. Each time the macro is performed, one or more rows of data can be returned. In other words, a macro defines a set of SQL statements that are frequently used or that performs a complex operation. The statements in the macro body are submitted when the macro is invoked by a subsequent EXECUTE statement.

In the adapter subscription, when the "Use Macros" field is selected, the adapter will create macros in the database for insert/update/delete/upsert operations, which will improve the performance.