9.2.1 Configuring PARALLEL Hint when Loading a Graph

You can also optimize the graph loading performance by configuring a specific parallel hint value using the GraphConfig field, PARALLEL_HINT_DEGREE, which will be used by the underlying SQL queries. This can be applied when loading a graph using a JSON configuration file or through the GraphConfigBuilder API.

The following table describes how the internal queries are configured based on the specified PARALLEL_HINT_DEGREE values.

Table 9-2 PARALLEL_HINT_DEGREE values

PARALLEL_HINT_DEGREE Value Parallel hint used in the SQL Statement
Positive integer(n) Uses the given n degree:

SELECT /*+ PARALLEL(n) */ ...

Zero Uses a plain hint:

SELECT /*+ PARALLEL */ ...

Negative integer

(Default value: -1)

No PARALLEL hint:

SELECT ...

See Also: