multiple accepted plans for a give statement

  • From: "Beckstrom, Jeffrey" <jbeckstrom@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 28 Sep 2021 11:58:21 +0000

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. 6th Street
Cleveland, Ohio 44113

Other related posts: