Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
geqo
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Enables genetic query optimization. This algorithm attempts to do planning without exhaustive searching. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | geqo |
geqo_effort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: effort is used to set the default for other GEQO parameters. |
| Data type | integer |
| Default value | 5 |
| Allowed values | 1-10 |
| Parameter type | dynamic |
| Documentation | geqo_effort |
geqo_generations
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of iterations of the algorithm. Zero selects a suitable default value. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_generations |
geqo_pool_size
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of individuals in the population. Zero selects a suitable default value. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_pool_size |
geqo_seed
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: seed for random path selection. |
| Data type | numeric |
| Default value | 0 |
| Allowed values | 0-1 |
| Parameter type | dynamic |
| Documentation | geqo_seed |
geqo_selection_bias
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: selective pressure within the population. |
| Data type | numeric |
| Default value | 2 |
| Allowed values | 1.5-2 |
| Parameter type | dynamic |
| Documentation | geqo_selection_bias |
geqo_threshold
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Sets the threshold of FROM items beyond which GEQO is used. |
| Data type | integer |
| Default value | 12 |
| Allowed values | 2-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_threshold |
geqo
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Enables genetic query optimization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | geqo |
geqo_effort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: effort is used to set the default for other GEQO parameters. |
| Data type | integer |
| Default value | 5 |
| Allowed values | 1-10 |
| Parameter type | dynamic |
| Documentation | geqo_effort |
geqo_generations
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of iterations of the algorithm. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_generations |
geqo_pool_size
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of individuals in the population. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_pool_size |
geqo_seed
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: seed for random path selection. |
| Data type | numeric |
| Default value | 0 |
| Allowed values | 0-1 |
| Parameter type | dynamic |
| Documentation | geqo_seed |
geqo_selection_bias
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: selective pressure within the population. |
| Data type | numeric |
| Default value | 2 |
| Allowed values | 1.5-2 |
| Parameter type | dynamic |
| Documentation | geqo_selection_bias |
geqo_threshold
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Sets the threshold of FROM items beyond which GEQO is used. |
| Data type | integer |
| Default value | 12 |
| Allowed values | 2-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_threshold |
geqo
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Enables genetic query optimization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | geqo |
geqo_effort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: effort is used to set the default for other GEQO parameters. |
| Data type | integer |
| Default value | 5 |
| Allowed values | 1-10 |
| Parameter type | dynamic |
| Documentation | geqo_effort |
geqo_generations
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of iterations of the algorithm. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_generations |
geqo_pool_size
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of individuals in the population. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_pool_size |
geqo_seed
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: seed for random path selection. |
| Data type | numeric |
| Default value | 0 |
| Allowed values | 0-1 |
| Parameter type | dynamic |
| Documentation | geqo_seed |
geqo_selection_bias
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: selective pressure within the population. |
| Data type | numeric |
| Default value | 2 |
| Allowed values | 1.5-2 |
| Parameter type | dynamic |
| Documentation | geqo_selection_bias |
geqo_threshold
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Sets the threshold of FROM items beyond which GEQO is used. |
| Data type | integer |
| Default value | 12 |
| Allowed values | 2-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_threshold |
geqo
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Enables genetic query optimization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | geqo |
geqo_effort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: effort is used to set the default for other GEQO parameters. |
| Data type | integer |
| Default value | 5 |
| Allowed values | 1-10 |
| Parameter type | dynamic |
| Documentation | geqo_effort |
geqo_generations
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of iterations of the algorithm. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_generations |
geqo_pool_size
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of individuals in the population. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_pool_size |
geqo_seed
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: seed for random path selection. |
| Data type | numeric |
| Default value | 0 |
| Allowed values | 0-1 |
| Parameter type | dynamic |
| Documentation | geqo_seed |
geqo_selection_bias
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: selective pressure within the population. |
| Data type | numeric |
| Default value | 2 |
| Allowed values | 1.5-2 |
| Parameter type | dynamic |
| Documentation | geqo_selection_bias |
geqo_threshold
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Sets the threshold of FROM items beyond which GEQO is used. |
| Data type | integer |
| Default value | 12 |
| Allowed values | 2-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_threshold |
geqo
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Enables genetic query optimization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | geqo |
geqo_effort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: effort is used to set the default for other GEQO parameters. |
| Data type | integer |
| Default value | 5 |
| Allowed values | 1-10 |
| Parameter type | dynamic |
| Documentation | geqo_effort |
geqo_generations
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of iterations of the algorithm. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_generations |
geqo_pool_size
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of individuals in the population. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_pool_size |
geqo_seed
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: seed for random path selection. |
| Data type | numeric |
| Default value | 0 |
| Allowed values | 0-1 |
| Parameter type | dynamic |
| Documentation | geqo_seed |
geqo_selection_bias
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: selective pressure within the population. |
| Data type | numeric |
| Default value | 2 |
| Allowed values | 1.5-2 |
| Parameter type | dynamic |
| Documentation | geqo_selection_bias |
geqo_threshold
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Sets the threshold of FROM items beyond which GEQO is used. |
| Data type | integer |
| Default value | 12 |
| Allowed values | 2-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_threshold |
geqo
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Enables genetic query optimization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | geqo |
geqo_effort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: effort is used to set the default for other GEQO parameters. |
| Data type | integer |
| Default value | 5 |
| Allowed values | 1-10 |
| Parameter type | dynamic |
| Documentation | geqo_effort |
geqo_generations
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of iterations of the algorithm. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_generations |
geqo_pool_size
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of individuals in the population. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_pool_size |
geqo_seed
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: seed for random path selection. |
| Data type | numeric |
| Default value | 0 |
| Allowed values | 0-1 |
| Parameter type | dynamic |
| Documentation | geqo_seed |
geqo_selection_bias
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: selective pressure within the population. |
| Data type | numeric |
| Default value | 2 |
| Allowed values | 1.5-2 |
| Parameter type | dynamic |
| Documentation | geqo_selection_bias |
geqo_threshold
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Sets the threshold of FROM items beyond which GEQO is used. |
| Data type | integer |
| Default value | 12 |
| Allowed values | 2-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_threshold |
geqo
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Enables genetic query optimization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | geqo |
geqo_effort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: effort is used to set the default for other GEQO parameters. |
| Data type | integer |
| Default value | 5 |
| Allowed values | 1-10 |
| Parameter type | dynamic |
| Documentation | geqo_effort |
geqo_generations
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of iterations of the algorithm. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_generations |
geqo_pool_size
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of individuals in the population. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_pool_size |
geqo_seed
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: seed for random path selection. |
| Data type | numeric |
| Default value | 0 |
| Allowed values | 0-1 |
| Parameter type | dynamic |
| Documentation | geqo_seed |
geqo_selection_bias
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: selective pressure within the population. |
| Data type | numeric |
| Default value | 2 |
| Allowed values | 1.5-2 |
| Parameter type | dynamic |
| Documentation | geqo_selection_bias |
geqo_threshold
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Sets the threshold of FROM items beyond which GEQO is used. |
| Data type | integer |
| Default value | 12 |
| Allowed values | 2-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_threshold |
geqo
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Enables genetic query optimization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | geqo |
geqo_effort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: effort is used to set the default for other GEQO parameters. |
| Data type | integer |
| Default value | 5 |
| Allowed values | 1-10 |
| Parameter type | dynamic |
| Documentation | geqo_effort |
geqo_generations
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of iterations of the algorithm. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_generations |
geqo_pool_size
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: number of individuals in the population. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_pool_size |
geqo_seed
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: seed for random path selection. |
| Data type | numeric |
| Default value | 0 |
| Allowed values | 0-1 |
| Parameter type | dynamic |
| Documentation | geqo_seed |
geqo_selection_bias
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | GEQO: selective pressure within the population. |
| Data type | numeric |
| Default value | 2 |
| Allowed values | 1.5-2 |
| Parameter type | dynamic |
| Documentation | geqo_selection_bias |
geqo_threshold
| Attribute | Value |
|---|---|
| Category | Query Tuning / Genetic Query Optimizer |
| Description | Sets the threshold of FROM items beyond which GEQO is used. |
| Data type | integer |
| Default value | 12 |
| Allowed values | 2-2147483647 |
| Parameter type | dynamic |
| Documentation | geqo_threshold |