New: see Reindexing all (quick way).

About indexing and unindexing

The same 'srv4 index' command used with Exalead, populates the 'gn_FullText' column when the full-text engine is SQL. For example:

srv4 index -conditions gn4:story

executed when 'Db.FullTextEngine' is 'Sql' fills the 'gn_FullText' column for all 'story' objects in the database.

Similarly the 'srv4 unindex' command executed when 'Db.FullTextEngine' is 'Sql' clears the 'gn_FullText' column for all the specified objects - i.e. sets it to null.

See also

srv4 index command.

Reindexing all (quick way)

Note

Indexes must be created manually on Oracle: the 'srv4 dbupdate' / 'srv4 dbcreate' commands create/modify full-text indexes only when using Microsoft SQL Server.

See also

About full-text indexes (SQL FTS)