Query Performance Optimization¶

The following properties significantly increase the performance of Embedded MPP queries. They are configurable in values.yaml:

Query Performance Optimization Properties¶
Property name	Default Value	Description
`parquetBatchReadOptimizationEnabled`	True	This optimization enables vectorized readings, which significantly improves performance. There is a separate property for each predefined catalog: hive, iceberg and delta.
`pushdownFilterEnabled`	True	This optimization makes table scan more efficient. There is a separate property for each predefined catalog: hive, iceberg and delta.
`quickStats`	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.
`enableDynamicFiltering`	True	This optimization significantly improves the performance of queries with selective joins by avoiding reading data that would be filtered by join condition.

USER MANUALS