only_json_values index parameter
Enable the only_json_values index parameter to index only the values in the JSON or BSON documents as unstructured text. The field names are not indexed.
You can index both field name-value pairs and values, but not field names, as unstructured text. The json_names or all_json_names index parameter enables the indexing of field name-value pairs. The include_contents index parameter enables the indexing of field names and values as unstructured text. Add the only_json_values index parameter to modify the behavior of the include_contents index parameter to omit field names from the contents field.
Example: Index values as unstructured text
The following statement creates a bts index with the only_json_values index parameter enabled on the example JSON docs column:
create index bts_idx
on json_tab (docs bts_json_ops)
using bts(only_json_values="yes"); The resulting index indexes the following unstructured text that contains only the values in the document in the contents field:
contents: jim flynn 29 dodge olds slim flynn lynnExample: Index all field name-value pairs and values as unstructured text
The following statement creates a bts index with the all_json_names, only_json_values, and include_contents index parameters enabled on the example JSON docs column:
create index bts_idx
on json_tab (docs bts_json_ops)
using bts(
all_json_names="yes",
include_contents="yes",
only_json_values="yes"); The resulting index contains the following 9 field name-value pairs and the values as unstructured text in the contents field:
givenname: jim
givenname: slim
givenname: lynn
age: 29
cars: dodge
cars: olds
surname: flynn
surname: flynn
surname: kim
contents: jim flynn 29 dodge olds slim flynn lynn kim