BLOB Vs XMLTYPE, which is better!!?
941376Jun 4 2012 — edited Jun 23 2012Hi all, we currently store our XMLs as BLOB in a relational table, now we need to do wildcard search on the XML and are thinking of changing the column to XMLTYPE for better performance. But still we know there are options for wildcard searching in BLOB itself, but we are worried about performance hit. Also it seems difficult to do XMLTYPE using hibernate. We would be transacting millions of XMLs per week.
Can you please suggest which out be the best datatype for the column, remain with BLOB or to go with XMLTYPE and also specify which type of indexing is better Oracle Free Text or Unstructured XMLIndex for XMLType considering better performance.
Thanks!!