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: 3920
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.