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	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-hint	String	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.
automatic	String	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.
prejoin	Boolean	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
	},
]
}