Workload-aware data encoding

One or more non-transitory computer-readable media storing a set of instructions, wherein the set of instructions includes instructions, which when executed by one or more hardware processors, cause:

• executing, by a database management system (DBMS), a workload set of queries, the workload set of queries referencing a plurality of data portions, on which a plurality of operations of the workload set are performed to generate output for the workload set of queries, the executing the workload set comprising:
• performing a first operation, of a first operator from the plurality of operations, on a first data portion, of the plurality of data portions, in a current encoding format;
• collecting first operation execution statistics by recording measurements from the performing of the first operation on the first data portion in the current encoding format;
• based on the first operation execution statistics, obtaining one or more first feature values of a first plurality of feature values for a machine learning model of the first operator;
• executing the machine learning model of the first operator with the one or more first feature values as input to the machine learning model of the first operator;
• based on the executing the machine learning model of the first operator, generating a first estimate of benefit amount in performing the first operation on the first data portion in an alternative encoding format, different from the current encoding format, over the performing the first operation on the first data portion in the current encoding format.