Hint Specifying Not to Use Global Plan Cache

Function

When global plan cache is enabled, you can use the no_gpc hint to force a single query statement not to share the plan cache globally. Only the plan cache within the current session lifecycle is retained.

Syntax

no_gpc

NOTE:

This parameter takes effect only for statements executed by PBE when enable_global_plancache is set to on.

Example

No result exists in the dbe_perf.global_plancache_status view, that is, no plan is cached globally.

Feedback
编组 3备份
    openGauss 2024-07-19 01:03:13
    cancel