FTS UI Search to Query Workbench

Full Text Search
10

With index:

SELECT *
FROM `my-bucket` x
WHERE SEARCH(x, { "query": "name.en:car" }, { "index": "my_fts_index_name" })

{
    "#operator": "Sequence",
    "~children": [
        {
            "#operator": "IndexScan3",
            "as": "x",
            "index": "objectType",
            "index_id": "77afcd28b7f45ff6",
            "index_projection": {
                "primary_key": true
            },
            "keyspace": "my-bucket-name",
            "namespace": "default",
            "spans": [
                {
                    "exact": true,
                    "range": [
                        {
                            "high": "\"MyObjectType\"",
                            "inclusion": 3,
                            "low": "\"MyObjectType\""
                        }
                    ]
                }
            ],
            "using": "gsi"
        },
        {
            "#operator": "Fetch",
            "as": "x",
            "keyspace": "my-bucket-name",
            "namespace": "default"
        },
        {
            "#operator": "Parallel",
            "~child": {
                "#operator": "Sequence",
                "~children": [
                    {
                        "#operator": "Filter",
                        "condition": "(((`x`.`objectType`) = \"MyObjectType\") and search(`x`, {\"query\": \"name.en:car\"}, {\"index\": \"my_fts_index_name\"}))"
                    },
                    {
                        "#operator": "InitialProject",
                        "result_terms": [
                            {
                                "expr": "self",
                                "star": true
                            }
                        ]
                    },
                    {
                        "#operator": "FinalProject"
                    }
                ]
            }
        }
    ]
}

Without index:

SELECT *
FROM `my-bucket` x
WHERE SEARCH(x, { "query": "name.en:car" })

{
    "#operator": "Sequence",
    "~children": [
        {
            "#operator": "IndexScan3",
            "as": "x",
            "index": "objectType",
            "index_id": "77afcd28b7f45ff6",
            "index_projection": {
                "primary_key": true
            },
            "keyspace": "my-bucket-name",
            "namespace": "default",
            "spans": [
                {
                    "exact": true,
                    "range": [
                        {
                            "high": "\"MyObjectType\"",
                            "inclusion": 3,
                            "low": "\"MyObjectType\""
                        }
                    ]
                }
            ],
            "using": "gsi"
        },
        {
            "#operator": "Fetch",
            "as": "x",
            "keyspace": "my-bucket-name",
            "namespace": "default"
        },
        {
            "#operator": "Parallel",
            "~child": {
                "#operator": "Sequence",
                "~children": [
                    {
                        "#operator": "Filter",
                        "condition": "(((`x`.`objectType`) = \"MyObjectType\") and search(`x`, {\"query\": \"name.en:car\"}))"
                    },
                    {
                        "#operator": "InitialProject",
                        "result_terms": [
                            {
                                "expr": "self",
                                "star": true
                            }
                        ]
                    },
                    {
                        "#operator": "FinalProject"
                    }
                ]
            }
        }
    ]
}