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 executeQuery and translateQuery

• Through flags in the options string argument of executeQuery and translateQuery

• Through Java JVM arguments.

The following table summarizes the available query arguments for PGQL translation and execution.

Table 6-6 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

• Query Options Controlled by Explicit Arguments
  
• Using the GT$ Skeleton Table
  
• Path Query Options
  
• Options for Partial Object Construction