Improved performance and memory tracking with IN operator optimization

Why it matters

This feature optimizes the execution of queries with the IN operator by leveraging table indexes, leading to faster query performance and lower memory usage. It also ensures accurate memory consumption tracking during such operations, addressing inefficiencies and resource management issues.

How to use it

Simply write queries using the IN operator with conditions that can utilize existing table indexes. No special configuration is required as the improvements are applied automatically during query processing.