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 |
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για