Query Tuning / Genetic Query Optimizer
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 |
Feedback
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați: https://aka.ms/ContentUserFeedback.
Trimiteți și vizualizați feedback pentru