Different PHV
Hi,
in Oracle 12.2.0.1, I don't understand why the CBO for the same delete request choose 2 different execution plan given that the second index contains only 3 column of the where clause and given that the request delete only one row.
I specify that the SCPCRHNUM column is unique.
The request use the correct index only the 06/06/2020, 13/06/2020 and 27/06/2020
Can you please enligthten me ?
License : T
Input : xxxx
RDBMS : 12.2.0.1.0
Platform : IBM/AIX RISC SYSTEM/6000
Database : DXSN1XXXX
Instance : 1
CPU_Count : 40
Num CPUs : 40
Num Cores : 10
Num Sockets:
Block Size : 8192
OFE : 12.2.0.1
DYN_SAMP : 0
EBS : ""
SIEBEL : ""
PSFT : ""
Date : 2020-07-02/18:50:23
User : SYS
delete from XXXX123.ZSCPCRH0 where XXXX_MBR = :1 and SCPCRHETA = :2 and SCPCRHTRA =