Full Text indexes allow to index text as single word and its radix. Full text indexes are like a search engine on your database. If you are using the Lucene engine, please refer to Lucene Full-Text index.
Example:
create index City.name on City (name) FULLTEXT
This will create a FullText index on the property name of the class City, with default configuration.
| Parameter | Default | Description |
|---|---|---|
| indexRadix | true | Word prefixes will be also index |
| ignoreChars | " |
Chars to skip when indexing |
| separatorChars | \r\n\t:;,.|+*/\=!?[](.md) |
|
| minWordLength | 3 | Minimum word length to index |
| stopWords | "the in a at as and or for his her him this that what which while up with be was were is" | Stop words escluded from indexing |
To configure fulltext index use the metadata field.
Example with SQL:
create index City.name on City (name) FULLTEXT METADATA {"indexRadix" : true, "ignoreChars" : "&" , "separatorChars" : " |()", "minWordLength" : 4 , "stopWords" : ['the','of']}
Example with Java;
OSchema schema = db.getMetadata().getSchema();
OClass city = schema.getClass("City");
ODocument metadata = new ODocument();
metadata.field("indexRadix", true);
metadata.field("stopWords", Arrays.asList(new String[] { "the", "in", "a", "at" }));
metadata.field("separatorChars", " :;?[](.md)");
metadata.field("ignoreChars", "$&");
metadata.field("minWordLength", 5);
city.createIndex("City.name", "FULLTEXT", null, metadata, null, new String[] { "name" });