4.5.1.1 Configuring PARALLEL Hint when Loading a Partitioned 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 partitioned graph either 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 4-7 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: