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 index concepts and reference.
Immediate The database server automatically refreshes this text index immediately after changes to underlying data affect data in the text index. See Text index concepts and reference.
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 clicking 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 index concepts and reference.
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. SeeText index concepts and reference.
Last refresh time Shows the date and time that the text index was last refreshed.
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.
Comment Provides a place for you to type a text description of the text index.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|