Home » RDBMS Server » Performance Tuning » No parallel DML with IOTs (oracle 10.2.0.3)
No parallel DML with IOTs [message #415609] Tue, 28 July 2009 06:15 Go to next message
prachij593
Messages: 266
Registered: May 2009
Senior Member
Quote:

No parallel DML with IOTs

It is not possible to use parallel DML in combination with (unpartitioned) Index Organized Tables (IOTs).

Source: http://www.saptechies.com/oracle-parallel-execution/



I am seeing parallel execution in a plan for an IOT .

Thanks

Re: No parallel DML with IOTs [message #415614 is a reply to message #415609] Tue, 28 July 2009 06:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not trust something that does not precise the Oracle version.

Quote:
I am seeing parallel execution in a plan for an IOT .

So show us.

Regards
Michel
Re: No parallel DML with IOTs [message #415657 is a reply to message #415614] Tue, 28 July 2009 09:37 Go to previous message
Alessandro Rossi
Messages: 166
Registered: September 2008
Location: Rome
Senior Member
Probably a fast full index scan that is implemented with a scattered read could be performed with parallelism.

But when it's performed in case of searching purpose (SELECTs or DMLs ) there may be no advantages on using an indexed structure! And sometime this is symptomatic for a faulty design too.

Bye Alessandro

[Updated on: Tue, 28 July 2009 09:42]

Report message to a moderator

Previous Topic: sqlarea sql
Next Topic: Rollback segment too small error
Goto Forum:
  


Current Time: Wed Dec 07 04:58:48 CST 2016

Total time taken to generate the page: 0.09070 seconds