Re: Why does a hard parse access data in the table in the query?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 7 Feb 2019 06:03:31 -0500
Message-ID: <5683f485-c744-c966-bd16-1bb3a1c970c6_at_gmail.com>
Date: Thu, 7 Feb 2019 06:03:31 -0500
Message-ID: <5683f485-c744-c966-bd16-1bb3a1c970c6_at_gmail.com>
Optimizer_dynamic_sampling > 0?
On 2/7/19 5:19 AM, Norman Dunbar wrote:
>
> I'm wondering why the (hard) parse needs to be reading multiple blocks
> (in the case of a sequential read) from a partition of one of the
> tables involved in the query?
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 07 2019 - 12:03:31 CET