Tables for Business Views

When creating custom business views, you must first select appropriate tables. The tables that you select must include the fields that are required to meet the business purpose. Although you can create one large business view to retrieve and update the columns that are required by the application, performance is negatively affected. Whenever possible, consider using table joins rather than creating one large business view that contains many data items.

Note: To ensure maximum performance in applications, use these guidelines for the number of tables that are joined in a business view:

Join five tables if all joins are simple joins.
Join three tables if any of the joins is an outer join or in the event of a table union.