Skip to Content
0
Former Member
May 29, 2008 at 11:54 AM

Performance tuning for JCDS query

187 Views

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?