This tab has the following components:
Name Shows the name of the text index.
Type Shows the type of object.
Table Shows the name of the table that is indexed, with the name of the table's owner in parentheses.
Dbspace Shows the database file (or dbspace) the text index is associated with.
Text configuration object Shows the name of the text configuration object for the text index, with the name of the text configuration object's owner in parentheses.
Refresh type Shows the type of refresh rate specified for the index. The default is Immediate. See Text indexes.
Immediate The database server automatically refreshes this text index immediately after changes to underlying data affect data in the text index. See Text indexes.
Once a text index is created, you cannot change it to, or from, immediate refresh. If either of these changes is required, you must drop the text index and create it again. See ALTER TEXT INDEX statement.
Manual You must refresh this text index manually; for example, by pressing Refresh Now. Data in manual text indexes can become stale because manual text indexes are not refreshed until a refresh is explicitly requested. See Text indexes.
Automatic The text index is automatically refreshed using a time interval that you specify. If some data staleness is acceptable, you can choose this refresh type and specify the time interval at which to refresh the text index. A query on a stale index returns matching data as of the last refresh. Rows that have been inserted, deleted, or updated since the last refresh are not returned by the query.Text indexes.
Refresh Now Click to refresh the text index; you are prompted to specify a consistency with which to refresh the text index. Refreshing a text index also initializes it. See REFRESH MATERIALIZED VIEW statement.
Truncate Now Click to delete all the rows in the text index and to change the state to uninitialized. See TRUNCATE statement.
Last refresh time Shows the date and time that the text index was last refreshed.
Comment Provides a place for you to type a text description of the text index.
See Text indexes.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|