optimize_index.json
optimize_index is the parameter file that defines the optimization methods that can be used during the Smart Tables process or manual optimizations launched from the table.
It refers to parameters defined in the Analyzer (Advanced mode).
Parameters
Parameter | Type | Choices/Default | Description |
---|---|---|---|
Name | String | Name of the optimization process. | |
coef | Double | Coefficient for splitting indexes. The more is value is high, the more indexes you will have. (decimal separator: point) | |
nbDays | Int | Number of days to get queries to analyze on. | |
minHits | Int | Minimum number of times a field appears in queries, so we should propose it. | |
spec | String |
|
|
index-hint | String |
|
|
automatic | String |
|
|
prejoin | Boolean |
| If true, pre-join indexes are proposed by the analyzer. |
Example
Optimize_index
{
"optimizations": [
{
"name": "Last month tuning",
"coef": 4.0,
"nbDays": 30,
"minHits": 1,
"spec":"NOT_SPECIALIZED",
"index-hint":"TUNING",
"automatic": "CREATE_DELETE",
"prejoin" : true
},
{
"name": "Last day tuning",
"coef": 4.0,
"nbDays": 1,
"minHits": 1,
"spec":"NOT_SPECIALIZED",
"index-hint":"TUNING",
"automatic": "CREATE_DELETE",
"prejoin" : true
},
]
}
JAVA