sa_text_index_vocab system procedure

Lists all terms that appear in a TEXT index, and the total number of indexed values that each term appears in.

sa_text_index_vocab(
	'text-index-name',
	'table-name',
	'table-owner'
	)

sa_text_index_vocab returns all terms that appear in a TEXT index, and the total number of indexed values that each term appears in (which is less than the total number of occurrences if the term appears multiple times in some indexed values).

sa_text_index_vocab has this limitation:

• Parameter values cannot be host variables or expressions. The arguments text-index-name, table-name, and table-owner must be constraints or variables.

DBA authority, or SELECT permission on the indexed table is required.

This example executes sa_text_index_vocab to return all the terms that appear in the TEXT index MyTextIndex on table Customers owned by GROUPO:

sa_text_index_vocab
(‘MyTextIndex’,‘Customers’,‘GROUPO’);