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

Report message to a moderator

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: 68665
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

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 12:04:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.