Maximum of 128 GB for a view index.
(16 M page of B-tree space, 8kB/page)
Also limited by available disk space (2 GB on some UNIX platforms).
View containers in R5 databases (ODS 3.1 up) do not have a container size limit. The view size limit is now determined by the maximum number of pages that can be created which is 16,777,214. A page holds 8 KB so that means the maximum size for a view is 137,438,937,088 bytes (128 GB).
Post a Comment