_ SYNC_ PLANS
Synchronizes a node's local PPC with the DPC for a specific database.
_SYNC_PLANS <dbName>;
When this command is run on a node, it downloads up to distributed_
from the DPC to that node's local PPC for the specified database.
The _
command first downloads one plan per table in the database.distributed_
, SingleStore recommends increasing the value of distributed_
to a value greater than the number of tables in the database before running the command.
When the _
command is run, a synchronization task will be added to the DPC task queue regardless of whether enable_ON
or OFF
.OFF
, the task will run when enable_ON
.
Refer to Distributed Plancache for more information.
Last modified: September 30, 2025