Feature Request: Prepared Statement Planning Improvement

[harshit-gangal]

Feature Description

Prepared statements are planned upon receiving the query, which may result in suboptimal plans due to unavailable parameter values. During the planning phase, we can merge complex operators into simpler, faster ones.

To improve performance, we can either delay planning until the first query with parameter values is received or use a conditional planner that makes informed assumptions about the parameters.

Use Case(s)

For building optimal query plans