Don't log large data objects (CLOBs, DBCLOBs, and BLOBs) unless necessary.
如果没有必要，不要记录大数据对象(CLOB、DBCLOB和BLOB)。
It scales with the database, and XML-specific optimizations give it better performance than CLOBs.
它可随数据库进行扩展，并且特定于XML的优化使得它具有比CLOB更好的性能。
Smart LOBs consist of character large objects (CLOBs) and binary large objects (BLOBs) data types.
智能大对象由字符大对象(CLOBs)和二进制大对象(BLOBs)数据类型组成。
Many database systems allow you to store XML data as CLOBs or "shred" the data into relational tables.
许多数据库系统允许将XML数据存储为clob格式，或将数据“分解”到关系表中。
That's a nice improvement over working with XML data as CLOBs or VARCHARs, which require maximum lengths.
与将XML数据作为CLOB或VARCHAR处理(这需要指定最大长度)相比，这是一项不错的改进。
Side tables can avoid much of the XML parsing for CLOBs and can often make CLOB queries 100 times faster or more.
索引表能够避免许多针对 CLOB的XML解析，这通常能够使CLOB查询速度快 100倍或更多。
This means that XML is either stored in files, stored wholesale in database CLOBs, or shredded into distinct columns.
这意味着XML可以存储在文件中，或者大量存储在数据库CLOB 中，或者解析为分离的列。
This function does not support CLOB data directly. However, CLOBs can be passed in as arguments through implicit data conversion.
此函数不直接支持CLOB数据。然而，CLOB可以作为参数通过隐式转换传入。
At present, stored procedures and user-defined functions do not have support for XML as a parameter, but they can easily be passed as CLOBs.
目前，存储过程和用户定义函数不支持XML作为参数，但是很容易作为CLOB传递XML。
With side tables, DB2 first performs an index lookup on the side table and then joins the corresponding row with the main table that contains the CLOBs.
在使用索引表的情况下，DB 2首先对索引表执行索引查找，然后将对应的行和包含CLOB的主表相结合。
As described above, the value of using an XML database (as opposed to CLOBs or shredding into relational data) is increased performance, XML fidelity, and simplified development.
如前所述，使用XML数据库的价值(相对于CLOB或分割为关系数据)是改进性能，提高xml精确度，以及简化开发。
However, for smaller documents, you can also specify a result type like VARCHAR that might be more appropriate and result in better performance than Character Large Objects (CLOBs).
然而，对于较小的文件，也可以指定像VARCHAR这样的结果类型，与CharacterLargeObjects (CLOB)比较而言，这种类型可能更为合适而且也会产生更好的性能。
Thus, the use of indexes and side tables typically reduces the absolute elapsed times for both XML and CLOBs, but does not erase the large relative performance advantage of XML over CLOB columns.
因此，使用索引和索引表通常能够缩短XML和CLOB的绝对占用时间，但是不会消除xml相对clob列较大的相对性能优势。
DB2 stores and processes XML in its inherent hierarchical format, avoiding the performance and flexibility limitations that occur when XML is stored as text in CLOBs or mapped to relational tables.
DB2以XML数据自身固有的分层格式存储和处理这些数据，避免因为将XML存储为CLOB中的文本或将它映射为关系表而导致的性能和灵活性限制。
DB2 stores and processes XML in its inherent hierarchical format, avoiding the performance and flexibility limitations that occur when XML is stored as text in CLOBs or mapped to relational tables.
DB2以XML数据自身固有的分层格式存储和处理这些数据，避免因为将XML存储为CLOB中的文本或将它映射为关系表而导致的性能和灵活性限制。
应用推荐