We tested the new query optimizer we have enabled for MSE, and we saw quite promising results (2-5x latency improvement with 50% less cpu utilization)

Creating this issue to share these results with the community for reference. We'll also update Pinot OSS Docs on how to configure your tables for Colocated Joins soon.

Link to doc. We have also added profiler results at the bottom: https://docs.google.com/document/d/1T55xwuYdTRXxrqbLwd7f5iOtlD0ftHyreU8c-XmyTYI/edit?tab=t.0#heading=h.bsqs4z7tog5l