Choose the appropriate storage data type

You can improve performance by choosing the appropriate storage data type for your data. This section describes the advantages and disadvantages of storing text documents in the following supported data types: BLOB, CLOB, LVARCHAR, IfxDocDesc, and IfxMRData.

Although you can also build an etx index on columns of type CHAR and VARCHAR, their small storage capacities make them unlikely choices for storing text documents and they are not discussed in this section.