[Meta] ES|QL Lookup Join Performance and Scalability #139194
Description
Lookup Join went GA in 8.19+9.1 and already includes performance optimisations. We want this important capability to be even faster, more efficient, and able to scale to even larger data sets and use cases. Here we can track ideas for performance optimisations.
- ESQL: Add optimization to purge join on null merge key #127583
- ESQL: Pushdown Lookup Join past Project #129503
- Improve Expanding Lookup Join performance by pushing a filter to the right side of the lookup join #133166
- Performance: Put multi-value warning for Lookup Join behind a feature flag. #137267
- Performance: Improve Lookup Join performance by caching field access #137268
- Performance: Improve LOOKUP JOIN on a single keyword performance by avoiding creating Lucene Query per Join #137269
- Performance: Lookup Join Dictionary Encoded Blocks optimization #137270