| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: parallel execution on partitioned tables (was: Oracle 9.2.0.5 "10046" Tracing ...)
I guess it also works that if your index is parallel but the table not
partitioned then the query will serialize. Though, I have seen parallel fast
full index scans on non-partitioned tables. Would this also be because of
the indexes created in parallel? Figures with oracle there is always a
tradeoff. Create indexes in parallel saves a massive amount of time but then
you have to alter them noparallel.
Mike
----- Original Message -----
From: "Tanel Põder" <tanel.poder.003_at_mail.ee>
To: <oracle-l_at_freelists.org>
Sent: Tuesday, August 03, 2004 1:57 PM
Subject: Re: parallel execution on partitioned tables (was: Oracle 9.2.0.5
"10046" Tracing ...)
> 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.
>
> 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
> -----------------------------------------------------------------
>
-- 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 - 13:05:15 CDT
 |
 |