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

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

 

Materialized View Properties window: Miscellaneous tab

This tab only applies to materialized views.

This tab has the following components:

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

  • Calculate   Calculates the number of rows in the view.

Free space   Specifies the amount of free space to reserve for each database page used for the materialized view. The free space is used when rows increase in size, for example due to updates.

  • Default   Choose this option to reserve 200 bytes in each page.

  • Percentage   Choose this option to specify an integer between 0 and 100. The former specifies that no free space is to be left on each page—each page is to be fully packed. A high value causes each row to be inserted into a page by itself.

For more information about how the Free Space setting works, see the PCTFREE clause of the ALTER VIEW statement. See ALTER VIEW statement.

Materialized 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