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 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.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1