I've a big problem on Oracle 12 DB.
This kind of query
SELECT
"MANDT", "MESTYPE", "CPIDENT", "PROCESS", "TABNAME", "TABKEY", "FLDNAME", "CRETIME", "ACTTIME",
"USRNAME", "CDOBJCL", "CDOBJID", "CDCHGNO", "CDCHGID"
FROM
"BDCP2"
WHERE
"MANDT"='730' AND "MESTYPE"='YOILDEB' AND "PROCESS"=' ' AND "CRETIME"<='20160721203056' AND "CDOBJCL"=
'CREDTEXT'
ORDER BY
"MANDT", "CPIDENT";
use always BDCP2-0 instead of the right index BDCP2-001.
THe execution time is about 20 minutes instead of 1 second...
How can I solve?
Regards,
Mario