optimize_index.json
optimize_index is a parameter file that defines the optimization methods you can use during the Smart Tables process or manual optimizations launched from the table.
The following parameters need to be defined in the Analyzer in Advanced mode.
Parameters
Parameter | Type | Choices/Default | Description |
---|---|---|---|
Name | String | Name of the optimization process. | |
coef | Double | Coefficient for splitting indexes. The higher the value, the more indexes you will receive (decimal separator: point). | |
nbDays | Int | Number of days to get queries to analyze on. | |
minHits | Int | Minimum number of times a field appears in SQL queries. | |
spec | String |
|
|
index-hint | String |
|
|
automatic | String |
|
|
prejoin | Boolean |
| If true, pre-join indexes are suggested by the analyzer. |
Example
Optimize_index
JAVA
{
"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
},
]
}