6.9.1.4.6 Additional Options for PGQL Translation and Execution
Several options are available to influence PGQL query translation and execution. The following are the main ways to set query options:
-
Through explicit arguments to
executeQueryandtranslateQuery -
Through flags in the
optionsstring argument ofexecuteQueryandtranslateQuery -
Through Java JVM arguments.
The following table summarizes the available query arguments for PGQL translation and execution.
Table 6-4 PGQL Translation and Execution Options
| Option | Default | Explict Argument | Options Flag | JVM Argument |
|---|---|---|---|---|
|
Degree of parallelism |
0 |
parallel |
none |
none |
|
Timeout |
unlimited |
timeout |
none |
none |
|
Dynamic sampling |
2 |
dynamicSampling |
none |
none |
|
Maximum number of results |
unlimited |
maxResults |
none |
none |
|
GT$ table usage |
on |
none |
USE_GT_TAB=F |
-Doracle.pg.rdbms.pgql.useGtTab=false |
|
CONNECT BY usage |
off |
none |
USE_RW=F |
-Doracle.pg.rdbms.pgql.useRW=false |
|
Distinct recursive WITH usage |
off |
none |
USE_DIST_RW=T |
-Doracle.pg.rdbms.pgql.useDistRW=true |
|
Maximum path length |
unlimited |
none |
MAX_PATH_LEN=n |
-Doracle.pg.rdbms.pgql.maxPathLen=n |
|
Set partial |
false |
none |
EDGE_SET_PARTIAL=T |
-Doracle.pg.rdbms.pgql.edgeSetPartial=true |
|
Project null properties |
true |
none |
PROJ_NULL_PROPS=F |
-Doracle.pg.rdbms.pgql.projNullProps=false |
|
VT$ VL column usage |
on |
none |
USE_VL_COL=F |
-Doracle.pg.rdbms.pgql.useVLCol=false |