_ 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