Inlined and compressed XML storage


If some or all of your XML documents are small enough to fit into their corresponding row on the base table page in the DAT objects, they can be inlined into the relational data row. This provides more direct access to the XML data and avoids the redirected access to the XDA objects. In case of XML documents are too large to be inlined, they are stored in the XDA objects as usual.

Advantages of replacing the XML tags with an integer includes:



Operations


Refer to the example on the right.


Note that the CREATE TABLESPACE statements may fail if they already exist in the database. If that's the case, you may ignore those errors.