REBUILD TEXT INDEX
Rebuilds
a text index on a table to include new data.
SYNTAX
| text_index_name |
Name
of the text index you want to rebuild. |
| table_name |
Name
of the table you want to rebuild the text index on. |
DESCRIPTION
The REBUILD
TEXT INDEX command rebuilds an existing text index on a table. This updates
the text index to include new data that has been added to the database
since the text index was originally created. To execute the REBUILD TEXT
INDEX command to rebuild a text index on a table, you must be the table
owner, have DBA or SYSADM security privileges, or have the INDEX privilege
for that table.
A text index
is a mechanism that provides fast access to rows in a table that contain
one or more words or phrases in columns containing text. Text indexes
contain a representation of all the text found in the text columns they
are based on, but the data is encoded and structured to make retrieval
much faster than directly from the table. Once you create a text index
on a table, its operation is transparent to users of the database; the
DBMS will use the index to improve full-text query performance whenever
possible.
When you
load data into a table, DBMaker will not update any text indexes on that
table. For this reason you should try to load all of your data before
creating a text index on a table, if possible. Rows containing matching
text that was entered into a table after the text index was created will
not be returned with the full-text query results. To include these rows
in the search results, you must rebuild the text index using the REBUILD
TEXT INDEX command.
EXAMPLE
The following
example rebuilds the text index named TxtIdx on the Employees table.
REBUILD TEXT INDEX TxtIdx FOR Employees
|
RELATED COMMANDS
<
LOCK TABLE | Contents
| REMOVE FROM GROUP >
|
