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

SAP Sybase SQL Anywhere 16.0 » Context-Sensitive Help » SQL Anywhere plug-in help » SQL Anywhere properties windows


Text Index Properties window: General tab

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.

 See also