Index using issue
Hi all,
We are facing a issue about index using.
when we start query without using optimizer_feature_enable(10.2.0.5) in HINT , we get full table sacn and so db file scattered read,more CPU. duration is 1h19
but when we put in HINT a optimizer_feature_enable(10.2.0.5) sql , index is used., duration is 9 mn
hour db version : 11.2.0.3
the value of the parameter : optimizer_feature_enable=11.2.0.3
we has tested with the parameter : optimizer_feature_enable=10.2.0.5 and execute sql without using optimizer_feature_enable in HINT , we get full table sacn and so db file scattered read,more CPU. . Duration is 1h19
We are facing a issue about index using.
when we start query without using optimizer_feature_enable(10.2.0.5) in HINT , we get full table sacn and so db file scattered read,more CPU. duration is 1h19
but when we put in HINT a optimizer_feature_enable(10.2.0.5) sql , index is used., duration is 9 mn
hour db version : 11.2.0.3
the value of the parameter : optimizer_feature_enable=11.2.0.3
we has tested with the parameter : optimizer_feature_enable=10.2.0.5 and execute sql without using optimizer_feature_enable in HINT , we get full table sacn and so db file scattered read,more CPU. . Duration is 1h19
0