29 | 03 | 2024
Latest Articles
Popular Articles

Database Design

Binary XML Storage

User Rating:  / 0
PoorBest 

Binary XML Storage

 

Binary XML is new in Oracle 11G

Prior to Oracle 11G we had the choice between

1. unstructured XML which is actually a (c)lob segment : better insert performance but poor query performance

2. structured XML which requires to register the XML schema prior to XML data insertion : better query performance but poor insert performance


The Binary XML data storage combines the best of both worlds

 


SQL> create table table_XML of XMLTYPE XMLTYPE STORE AS BINARY XML;

Table created.