solidDB Help : solidDB reference : SQL: Statements : SET : SET GRID READ
  
SET GRID READ
Note Check the solidDB Release Notes for any limitations that are associated with using this statement with a grid in the current release.
SET GRID READ {LOCAL | DEFAULT}
Access requirements
Database user
Usage
Use the SET GRID READ statement to specify where SELECT statements run when executed in a solidDB grid.
The SET GRID READ statement takes effect immediately, starting from the next SQL statement.
For more information, see Routing SELECT statements.
Parameters, clauses, keywords, and variables
▪ LOCAL: Forces the statement to run on the current grid node. The node does not route the statement or any query fragments to any other nodes in the grid. The local mode is valid until the connection is closed or the default behavior is restored.
Note Using SET GRID READ LOCAL does not prevent query fragments (from distributed queries that are initiated on other nodes) from being executed on the current node.
▪ DEFAULT: Default behavior is restored; the node initiates a distributed query that involves running query fragments on other nodes in the grid and consolidating the results.
Example
SET GRID READ LOCAL
Go up to
SET