Re: Parallel Query Question

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 23 Feb 2000 04:01:51 GMT
Message-ID: <38b35673.508042256@news.eagles.bbs.net.au>

Hi Jonathan,

I don't think this is right. Parallel table scans work by getting each slave to scan a rowid range using an SQL statement with the ROWID hint. Unless there is some equivalent hint to do a partial fast full scan, I don't see how a fast full scan could be parallelized. Am I missing something?

Regards,
Steve Adams

http://www.ixora.com.au/

http://www.oreilly.com/catalog/orinternals/

http://www.christianity.net.au/

On Sun, 20 Feb 2000 19:21:56 -0000, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>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.
>
Received on Tue Feb 22 2000 - 22:01:51 CST