TIL in Oracle database 19c that when the optimizer uses the result cache in an execution plan, the hash value can stay the same. Even more surprising is that the result cache is large and heavily leveraged in Oracle Autonomous... a feature that has been around for maybe 10 years and I thought long forgotten. #OracleDB
