Hi All,
I have a performance issue in following query.Any Idea how can it be improved?
SELECT objnr udate utime
FROM jcds
INTO TABLE it_jcds
WHERE objnr LIKE c_or
AND stat = l_tj02t
AND cdtcode LIKE c_co
AND inact = space.
Fields Distinct values
CDTCODE 111
INACT 192
Only one index i.e Primary Index
UNIQUE Index JCDS~0 (Compute)
Column Name #Distinct
MANDT 3
OBJNR 2.165.245
STAT 100
CHGNR 319
Is 'like' statement causing the performance issue and how can it be corrected?
Or Index can be created for this?