Full text search index not use

[constantin]

hello,
i’m experimenting full text search indexes. I configured Search on test environment, create a full text index on travel-sample.inventory.airport collection.
I use this query (in the query workbench) to force use of that index.

SELECT META().id, airportname, city, country

FROM travel-sample

WHERE SEARCH(travel-sample, ‘san francisco’)

ORDER BY SEARCH_SCORE(travel-sample);

Index is created and idle.

but, when i tried to see using explain if the index is used i see that is not :

[
{
“cardinality”: 6479,
“cost”: 35212.018707225034,
“plan”: {
“#operator”: “Sequence”,
“~children”: [
{
“#operator”: “Sequence”,
“~children”: [
{
“#operator”: “PrimaryScan3”,
“index”: “#sequentialscan”, <<<<<<<

not sure what i’m doing wrong and how can i force to use that full text searc index.

[constantin]

see below index definition :
{
“type”: “fulltext-index”,
“name”: “travel-sample.inventory.airport-index”,
“uuid”: “4e1d89cb71a6a012”,
“sourceType”: “gocbcore”,
“sourceName”: “travel-sample”,
“sourceUUID”: “d51eb070b4d8aef6a4aa6ba7e599e489”,
“planParams”: {
“maxPartitionsPerPIndex”: 512,
“indexPartitions”: 2,
“numReplicas”: 1
},
“params”: {
“doc_config”: {
“docid_prefix_delim”: “”,
“docid_regexp”: “”,
“mode”: “scope.collection.type_field”,
“type_field”: “type”
},
“mapping”: {
“analysis”: {},
“default_analyzer”: “standard”,
“default_datetime_parser”: “dateTimeOptional”,
“default_field”: “_all”,
“default_mapping”: {
“dynamic”: false,
“enabled”: false,
“properties”: {
“airportname”: {
“dynamic”: false,
“enabled”: true,
“fields”: [
{
“docvalues”: true,
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “airportname”,
“store”: true,
“type”: “text”
}
]
},
“city”: {
“dynamic”: false,
“enabled”: true,
“fields”: [
{
“docvalues”: true,
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “city”,
“store”: true,
“type”: “text”
}
]
},
“country”: {
“dynamic”: false,
“enabled”: true,
“fields”: [
{
“docvalues”: true,
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “country”,
“store”: true,
“type”: “text”
}
]
}
}
},
“default_type”: “_default”,
“docvalues_dynamic”: false,
“index_dynamic”: true,
“store_dynamic”: true,
“type_field”: “_type”,
“types”: {
“inventory.airport”: {
“dynamic”: true,
“enabled”: true,
“properties”: {
“airportname”: {
“dynamic”: false,
“enabled”: true,
“fields”: [
{
“docvalues”: true,
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “airportname”,
“store”: true,
“type”: “text”
}
]
},
“city”: {
“dynamic”: false,
“enabled”: true,
“fields”: [
{
“docvalues”: true,
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “city”,
“store”: true,
“type”: “text”
}
]
},
“country”: {
“dynamic”: false,
“enabled”: true,
“fields”: [
{
“docvalues”: true,
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “country”,
“store”: true,
“type”: “text”
}
]
}
}
}
}
},
“store”: {
“indexType”: “scorch”,
“segmentVersion”: 15
}
},
“sourceParams”: {}
}