Re: multiple accepted plans for a give statement

 Based on this diagram, seems like it would be the  

lowest cost plan                  

>
> On Sep 28, 2021 at 7:58 AM, <Jeffrey Beckstrom (mailto:jbeckstrom_at_gcrta.org)> wrote:
>
>
>
>
>
> If I have sql for which I have accepted more than one plan in the baseline, how does Oracle decide which of the accepted plans in the baseline to use?
>
>
>
>
>
>
>
> Jeffrey Beckstrom
>
>
>
> Greater Cleveland Regional Transit Authority
>
>
>
> 1240 W. 6 (x-apple-data-detectors://2)th (x-apple-data-detectors://2)Street (x-apple-data-detectors://2)
>
>
>
> Cleveland, Ohio 44113 (x-apple-data-detectors://2)
>
>
>
>
>
>
>
>
         

--
http://www.freelists.org/webpage/oracle-l