Skip to main content
Skip table of contents

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

ParameterType Choices/DefaultDescription
NameString
Name of the optimization process. 
coefDouble
Coefficient for splitting indexes. The higher the value, the more indexes you will receive (decimal separator: point).
nbDaysInt
Number of days to get queries to analyze on.
minHitsInt
Minimum number of times a field appears in SQL queries.
specString
  • NOT_SPECIALIZED
  • HALF_SPECIALIZED
  • FULLY_SPECIALIZED
  • NOT_SPECIALIZED : Expressions are proposed for the high cardinality field.
  • HALF_SPECIALIZED : Only expressions in the SELECT and WHERE clauses, for the high cardinality field, are proposed.
  • FULLY_SPECIALIZED : Expressions are always proposed.
index-hintString
  • TUNING
  • FULL
  • TUNING : Limit index changes by maximizing current index usage. This option allows you to use fewer, more compact indexes, even if some queries will have to use the K-Store.
  • FULL : All suggestions are shown, thus displaying at least one index for each query. This option may use more memory, but ensures adequate performance.
automaticString
  • CREATE_ONLY
  • CREATE_DELETE
  • LOG
  • CREATE_ONLY : Create all index suggestions, but do not remove any.
  • CREATE_DELETE : Create and delete all indexes suggestions.
  • LOG : log what could have been kept if the CREATE_DELETE mode had been used.
prejoinBoolean
  • True
  • False
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
	},
]
}
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.