|
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.
Calculate Calculates the number of rows in the view.
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.
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.
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.