Home » SQL & PL/SQL » SQL & PL/SQL » Huge XML data in BLOB columns (Oracle 10g)
Huge XML data in BLOB columns [message #674972] Tue, 26 February 2019 11:37 Go to next message
Danny Freeman
Messages: 21
Registered: December 2015
Location: UK
Junior Member
Hi. Just a curious question. Need a little guidance or suggestions. Suppose there is a huge XML data in BLOB columns. Now, to run an insert from these XML blobs they just put it in jobs. Now my question is, I'm trying to apply primary and secondary indexes on this field and it's taking 3+ hrs. Any suggestions?
Re: Huge XML data in BLOB columns [message #674973 is a reply to message #674972] Tue, 26 February 2019 11:46 Go to previous messageGo to next message
BlackSwan
Messages: 26649
Registered: January 2009
Location: SoCal
Senior Member
Danny Freeman wrote on Tue, 26 February 2019 09:37
Hi. Just a curious question. Need a little guidance or suggestions. Suppose there is a huge XML data in BLOB columns. Now, to run an insert from these XML blobs they just put it in jobs. Now my question is, I'm trying to apply primary and secondary indexes on this field and it's taking 3+ hrs. Any suggestions?

IMO, XML should be stored as XMLtype or CLOB; not BLOB.

ALWAYS post Oracle version to 4 decimal places.

We don't know what you have.
We don't know what you do.

we need a few more details.
http://www.orafaq.com/forum/mv/msg/84315/433888/#msg_433888
Please refer to URL above & be sure to provide the details requested:
1) DDL for all tables & indexes
2) EXPLAIN PLAN
3) output from SQL_TRACE & tkprof

Re: Huge XML data in BLOB columns [message #674974 is a reply to message #674972] Tue, 26 February 2019 13:44 Go to previous message
Michel Cadot
Messages: 66803
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What do you mean b"primary and secondary indexes"?
As BlackSwan says, post all what can lead to understand what you do and enable us to do the same thing.

Previous Topic: INSERT and SELECT statements
Next Topic: How to denormalize multiple records into 1 row-
Goto Forum:
  


Current Time: Tue Jan 28 06:12:28 CST 2020