Query Performance Optimization¶
The following properties have been found to increase the performance of Embedded MPP queries. They are configurable in values.yaml:
Property name |
Default Value |
Description |
|---|---|---|
|
False |
This optimization enables vectorized readings, which significantly improves performance. Still, the default value will remain false, as reading complex types with decimals inside with the property enabled will result in an error. But, in any other case, it is strongly recommended to enable it. There is a separate property for each predefined catalog: hive, iceberg and delta |
|
True |
This optimization makes table scan more efficient. There is a separate property for each predefined catalog: hive, iceberg and delta. |
|
True |
This optimization builds stats from metadata when statistics are missing, which significantly improves performance. There is a separate property for each predefined catalog: hive, iceberg and delta. |
|
True |
This optimization significantly improves the performance of queries with selective joins by avoiding reading data that would be filtered by join condition. |