Table-Based Views

The Table-Based Views option is available for all accounts, and enables you to specify that particular access accounts will contain Oracle tables of extracted data instead of views. Queries against table-based extracted data will reduce activity against the RESPONSES and RECEIVED_DCMS tables. You can also control indexing of these tables.

Despite its name, the Table-based Views option still enables you to see views with the names of DCMs or View Definitions that are based on the data extract tables.

When you create a table-based view, you need to choose a tablespace for tables and one for indexes that is large enough to meet your needs. The Maintain Study Access Accounts window provides fields for you to enter these tablespaces.

Some relevant information to help in estimating tablespace may be found in the table VIEW_ACCOUNT_STATISTICS in the RXC account. See the Oracle AS10gR2 documentation for information about calculating the space needed.

Note:

Union views cannot be represented as tables.