Re: Full table scans and USE

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 22 Sep 2000 19:00:59 +0100
Message-ID: <969645923.10225.0.nnrp-07.9e984b29@news.demon.co.uk>

Depending on the join conditions and the available indexes, a use_hash hint can

(a) run parallel and
(b) use indexes

To be safe you might as well use the HINT.

--

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

sergey_s_at_my-deja.com wrote in message <8qg24j$8am$1_at_nnrp1.deja.com>...


>If I process a query in parallel, will USE_HASH hint automatically cause

>full table scans even if there are indexes present? Or do I have to

>specify a FULL hint as well to ensure that the tables are scanned for

>the parallel processing?

>

>Thank you!

>Sergey

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.

Received on Fri Sep 22 2000 - 13:00:59 CDT

Re: Full table scans and USE_HASH hint