Article Parani.K · Mar 2 8m read

Parallel Query Processing - (System-wide and Query-based)

Parallel query hinting boosts certain query performances on multi-processor systems via parallel processing. The SQL optimizer determines when this is beneficial. On single-processor systems, this hint has no effect.

Parallel processing can be managed by:

  1.  Setting the auto parallel option system-wide.

  2. Using the %PARALLEL keyword in the FROM clause of specific queries.

%PARALLEL is ignored when it applied to:

#InterSystems IRIS #CSP #Globals #Management Portal #Security #SQL
0
0 0