Skip to main content

Fulltext Search vs. Fulltext Index

Macrometa offers both fulltext search views and fulltext indexing. While similar, these features are not identical.

This table compares search views and full-text indexes:

FeatureSearchFull-text Index
Term searchYesYes
Prefix searchYesYes
Boolean expressionsYesRestricted
Range searchYesNo
Phrase searchYesNo
Relevance rankingYesNo
Configurable AnalyzersYesNo
C8QL composable languageYesNo
Indexed attributes per collectionUnlimited1
Indexed collectionsUnlimited1

Search views ensure optimal execution plans (merge join) for multi-attribute queries. For more on full-text indexes, see Indexing.