[SERVER-80761] [CQF] Efficient lowering of sampling plans to SBE Created: 05/Sep/23  Updated: 27/Nov/23  Resolved: 27/Nov/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Svilen Mihaylov (Inactive) Assignee: Svilen Mihaylov (Inactive)
Resolution: Won't Fix Votes: 0
Labels: M1
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Optimization
Participants:

 Description   

 

  • Create a custom lowering transport for sampling queries.
  • Add handlers for
  • PhysScan
  • Eval
  • Filter
  • Limit
  • NLJ
  • No use of cascades properties: will need to make use of FieldProjectionMap of sargable node.
  • Use SBEExpressionLowering to lower expressions directly which hang off of Filter and Eval nodes.
  • Add a node that counts on top (group)
  • might be simpler to do during this lowering


 Comments   
Comment by Svilen Mihaylov (Inactive) [ 27/Nov/23 ]

Closing ticket. We still need to use ref tracker and a separate transport will not make sense.

Generated at Thu Feb 08 06:44:30 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.