Re: Parallel Query Question

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 20 Feb 2000 19:21:56 -0000
Message-ID: <951075030.25957.0.nnrp-02.9e984b29@news.demon.co.uk>

If you use the hint INDEX_FFS along with a parallel hint I think it is possible to get a parallel scan on the index.

This, however, is not an index full scan (which is a single block access method
on key order), but a 'tablescan' on the index blocks - reading them in physical order, discarding branch as it goes.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Buck Turgidson wrote in message ...
>According to the Server Concepts document, a statement is parallelizable if
>(1) it includes a hint or the table/index has a degree of paralleism and
>(2), at least one of the tables will be a full-table-scan or an index range
>scan on a partition.
>
>That said, we want to use PQ in 7.3.4 (partitioning unavailable). We have
>tuned the query such that it does a full index scan without access by
rowid.
>Since it is an index scan and not a FTS, will it run in parallel?
>
>
Received on Sun Feb 20 2000 - 13:21:56 CST