Strange things with the Oracle optimizer
Recently I needed to investigate a performance problem for 2 customers, which turned out to be problematic execution plans. It had the smell of Oracle optimizer bugs all over them. Although the first one is maybe somewhat self-inflicted injury. Both environments were using Oracle 12.1.0.2 with the October 2017 patch set. Case 1: functions on…