Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: parallel execution on partitioned tables (was: Oracle 9.2.0.5 "10046" Tracing ...)

Re: parallel execution on partitioned tables (was: Oracle 9.2.0.5 "10046" Tracing ...)

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Tue, 3 Aug 2004 20:57:38 +0300
Message-ID: <033001c47983$5e88b230$9c969fd9@porgand>


Btw, if you hint your query to use full table scans now or not to use your bitmap index (this means optimizer won't consider accessing your "parallel" index), the query will run in serial, because optimizer only sees noparallel objects.

It works the other way too, that if your table is parallel, but it's contents are accessed from a noparallel index, optimizer won't take the parallel degree of underlying table into account...

Tanel.

> Well now I can go home because I've learned something today. Never looked
at
> degree in dba_indexes. I create all of my indexes in parallel which I
guess
> automatically puts as degree = 'DEFAULT'. I have only seen this effect on
my
> partitioned tables. This is good, time for some serious testing.
>
> Thanks
> Mike



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Aug 03 2004 - 12:53:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US