发布

  • [NA] [BE] Optimize experiment items output columns query (#4927)

    frostbyte_neo 发布于 2026-01-28 11:03:24 +00:00

    • [NA] [BE] Optimize experiment items output columns query

    Replace complex arrayFold operation with efficient ARRAY JOIN pattern in
    SELECT_EXPERIMENT_ITEMS_OUTPUT_COLUMNS query. This optimization improves
    query performance by 34% while maintaining identical results.

    • Revision 2: Remove redundant experiment_items_scope scan in join

    • Revision 3: Simplify to IN subquery for better index usage

    • Add test

    下载附件