Database Design

Binary XML Storage

User Rating:

/ 0

Details: Parent Category: Articles; Created on Sunday, 21 March 2010 21:24; Last Updated on Saturday, 26 October 2013 20:07; Published on Sunday, 21 March 2010 21:24; Written by Guy Lambregts; Hits: 3931

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.