When a TdParameter is created for a LOB, the following recommendations will help when the Data Provider is inspecting LOB parameters to determine which LOBs can be optimized:

1. Always set the TdParameter.Size greater than 0.
2. When possible, use a String or Char Array to represent the data of a small LOB. There is less overhead to process the data.
3. When connected to a Teradata Release earlier than 15.0 and batching, keep the length of LOB parameters in the same row position (parameter column) a consistent length. Refer to Compare and Contrast SLOB and In-Lining for more information.