Skip to Content
0
Jul 22, 2016 at 07:36 AM

BDCP2 use wrong index

114 Views

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