This tab specifies information about the selected text index.
Name Shows the name of the text index.
Type Shows the type of object.
Table or Materialized View Shows the name of the table or the materialized view that is indexed, with the name of the owner in parentheses.
Dbspace Shows the database file (or dbspace) the text index is associated with.
Text configuration object Shows the name and owner of the text configuration object for the text index.
Initialized Shows whether the text index is initialized. You must initialize a text index to make it available for use by the database server. To initialize the text index, click Refresh Now.
The following options appear when the text index applies to a table and the refresh type for the text index is manual or automatic:
Refresh Now Click this button to refresh the text index; you are prompted to choose an isolation level to refresh the text index. Refreshing a text index also initializes it. See REFRESH MATERIALIZED VIEW statement.
Truncate Now Click this button to delete all the rows in the text index and to change the state to uninitialized. See TRUNCATE statement.
Refresh type Shows the type of refresh rate specified for the index.
Immediate The database server automatically refreshes this text index immediately after changes to underlying data affect data in the text index. This refresh type is the default, and it is the only refresh type for text indexes on materialized views.
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 recreate it.
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.
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 how frequently the database server refreshes 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.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|