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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » SQL Anywhere Plug-in Help » Introduction to SQL Anywhere property sheets

View property sheet: Permissions tab Next Page

View property sheet: Miscellaneous tab

This tab only applies to materialized views.

The Miscellaneous tab of the View property sheet has the following components:

Maximum view width    The number of bytes required for each row in the view.

Number of rows    Shows the approximate number of rows in the view. To update this value, click Calculate.

Free space    Specifies the amount of free space you want to reserve for each view page. The free space is used if rows increase in size when the data is updated. If there is no free space in a view page, every increase in the size of a row on that page requires the row to be split across multiple view pages, causing row fragmentation and possible performance degradation.

See ALTER VIEW statement.

View data is encrypted    When the database is created with table encryption scope, you can select this option to encrypt this materialized view's data.

See also