Built with CREATE FULLTEXT INDEX, this token-based index covers xml, character or varbinary(max) columns in a table or indexed view. Each table can have just one, and it needs a single-column, unique, non-nullable key index.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Full-text index in context, with comparison tables and the common traps.
Terms in this definition
- CRUD
Shorthand for create, read, update and delete, the four basic things you do with data. Data-plane roles in Azure Cosmos DB, for instance, authorise those operations on items.
- Index
Speeds up queries that filter on certain columns by keeping those columns sorted, with pointers back to each row; the price is more storage and slower writes.
- XML
A text-based format for data, used for instance in message bodies.
- MAX
Gives back the biggest value found in a column holding numbers, dates or text, or compares two expressions and returns the bigger. For TRUE/FALSE values, which this DAX aggregation doesn't accept, turn to MAXA.
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- Indexed view
When a view is given a unique clustered index, SQL Server materialises its output and maintains it much as it would a table. Creating one requires SCHEMABINDING plus particular SET options, and changes to the underlying base tables are applied to it too.
- Index field attributes
Settings applied to each field in an Azure AI Search index:
searchablefor full text,retrievableto return it,filterablefor exact-match$filter,sortable,facetablefor counts, andkeyfor the unique document ID.
Related terms
- CONTAINS
Searches columns with a full-text index for words, phrases, prefixes, inflected forms or synonyms; you use it as a predicate in
WHERE. - Full-text catalog
A logical grouping for full-text indexes, made with CREATE FULLTEXT CATALOG before any full-text index can exist. It is virtual and doesn't sit in any filegroup.
- Full-text policy
Declares, for a Cosmos DB for NoSQL container, the language and paths of its text fields. Combined with a full-text index defined in the indexing policy, this lets hybrid and full-text searches run efficiently.
- Full-text population
Filling or refreshing a full-text index, done as a full population, through change tracking (manual or automatic), or incrementally, which needs a timestamp column.