optimizer_features_enable

Oracle: A possible method to address a slow query if there is time pressure

Sometimes there is no time for a long analysis of a slow query and a fix (workaround) has to be provided asap. In such cases it often helps to check if a query did run faster with a previous OPTIMIZER_FEATURES_ENABLE-setting.