A.12.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
executeQuery
andtranslateQuery
-
Through flags in the
options
string argument ofexecuteQuery
andtranslateQuery
-
Through Java JVM arguments.
The following table summarizes the available query arguments for PGQL translation and execution.
Table A-3 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 |
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 |