Limiting Extension Columns

This topic is part of Guidelines for Data Objects Layer.

Adding extension columns to base tables can also affect performance, depending on the data type and length, the joins and queries used, the number of columns, and other considerations. For example, it is recommended not to add more than three columns of the data type CLOB to a base table. See also Reusing Standard Columns.