intuitively observe whether a SQL used session or global binding #16425
Labels
component/bindinfo
epic/sql-plan-management
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
Milestone
Description
#16127 suggests adding additional information to indicate that a query hit the plan cache.
SQL Plan Binding may also need the same improvement: how to intuitively observe whether a SQL used the session or global level binding?
For now, users have to check whether the execution plan is matched with the hints in the binding. But this method requires the user to be very similar to the optimizer and SQL hint behaviors.
Considered that the binding creator and the binding user might not the same person. For example, a binding creator may be the database administrator while a user may be the application developer.
Like plan cache, it's better to display this information in:
@@last_plan_from_baselines
to indicate whether the last executed statement used the plan specified by SPM plan baselines.The text was updated successfully, but these errors were encountered: