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


Materialized View Properties window: General tab

This tab has the following components:

  • Name   Shows the name of the materialized view.

  • Type   Shows the type of view.

  • Owner   Shows the database user who owns the view.

  • Dbspace   Shows the database file (or dbspace) where the view is located.

  • Status   Shows the status of the view. If the status is Enabled, the view is available for use by the database server. This status is synonymous with the ENABLED clause in the ALTER MATERIALIZED VIEW statement. If the status is Disabled, the view has been explicitly disabled by the user.

    See Materialized view statuses and Advanced: Status and properties for materialized views.

    • Recompile and Enable Now   Click this button to recompile and enable the view, making it available for use. Afterward, click Refresh Now to refresh the view, and then rebuild the indexes. If necessary, change the view back to an immediate view. See Enabling or disabling a materialized view.

    • Disable Now   Click this button to disable the view. When you disable a materialized view, the data and indexes for the view are dropped. Also, when you disable an immediate view, it is changed to a manual view. The database server keeps the definition of the materialized view in the database.

      Regular views that are dependent on a materialized view are automatically disabled by the database server if the view is disabled. See Enabling or disabling a materialized view.

  • Used in optimization   Select this option to indicate whether the materialized view can be used by the optimizer. The optimizer ignores disabled views. If you disable the view, the Used In Optimization option remains selected, so that when you re-enable the view, its setting is remembered. See Tip: Use materialized views to improve query performance.

  • Initialized   Shows whether the view is initialized. You must initialize a materialized view to make it available for use by the database server. To initialize the view, click Refresh Now.

    • Refresh Now   Click this button to refresh the view; you are prompted to specify the type of refresh to perform. See REFRESH MATERIALIZED VIEW statement.

    • Truncate Now   Click this button to delete all the rows in the view and to change the state to uninitialized. See TRUNCATE statement.

  • Refresh type   Specifies whether the view is a manual view or an immediate view. The default is Manual.

  • Immediate Compatible   Specifies whether the view is compatible with an immediate view. If immediate view is not compatible, clicking Details explains the reason.

  • Last refresh time   Shows the date and time that the view was last refreshed.

  • Known stale time   Shows the time at which the view became known as stale. This property only applies to manual views and corresponds to the time that a change was made to an underlying base table.

  • Comment   Provides a place for you to type a description of the view. For example, you could use this area to describe the view's purpose in the system. If you use the Database Documentation Wizard to document your SQL Anywhere database, you can include these comments in the output. See Documenting a database.

 See also