Home » RDBMS Server » Server Utilities » How to increase perfromance while loading data into IOT's?
How to increase perfromance while loading data into IOT's? [message #298385] Wed, 06 February 2008 00:15 Go to next message
susant_sabat
Messages: 1
Registered: February 2008
Junior Member
How to increase perfromance while loading data into IOT's?
Currently it is loading around 14 million rows in 50 mins using conventional path loading. (Assuming we can't use direct path loading here)
Are there any best practices?
Re: How to increase perfromance while loading data into IOT's? [message #298396 is a reply to message #298385] Wed, 06 February 2008 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Assuming your prerequisites, no.

Regards
Michel
Re: How to increase perfromance while loading data into IOT's? [message #298629 is a reply to message #298396] Wed, 06 February 2008 20:10 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Out of interest, load it into a regular (heap-organised) table and then how long does it take to build an index-organised table from that heap-organised table using CREATE TABLE ... AS SELECT (CTAS) syntax.

If the CTAS is faster than the conventional path load (and it should be) then you might find that rebuilding the IOT each time from an EOT would be the best option.

Ross Leishman
Previous Topic: sql loader: no record inserted
Next Topic: Error during import using Impdp
Goto Forum:
  


Current Time: Sat Dec 03 00:56:59 CST 2016

Total time taken to generate the page: 0.11216 seconds