Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Context-Sensitive Help » SQL Anywhere plug-in help » Introduction to SQL Anywhere properties windows


Text Index Properties window: General tab

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.