Re: Using parallel query on range partitioned table
Date: Tue, 25 Mar 2008 09:59:56 +0100 (CET)
Message-ID: <40569.213.162.65.111.1206435596.bloek@pwebmail6.utanet.at>
Hi,
>
> I am trying to use parallel hint for the following query that uses a
> range partitioned table/local index.
> - can I make use of parallel query where partition pruning occurs but it
> makes use of index range scan on the relevant partitions
Yes, you ought to use PARALLEL_INDEX hint, see
http://www.oracle.com/pls/db92/db92.to_URL?remark=drilldown&urlname=http:%2F%2Fdownload.oracle.com%2Fdocs%2Fcd%2FB10501_01%2Fserver.920%2Fa96533%2Fhintsref.htm%237420
It opens a separate index range scan per partition.
Consider that two preconditions should be fulfilled to deploy this access
path
a) the index range scan is the optimal access path
b) the number of records in the range in each partition is big enough to
compensate the overhead of parallel processing
Regards,
Jaromir D.B. Nemec
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 25 2008 - 03:59:56 CDT