topic Re: Performance issue -Select single statement -CKIS table in Application Development and Automation Discussions

Performance issue -Select single statement -CKIS table

Former Member — Wed, 31 Jan 2007 16:15:44 GMT

Hi,

Here is the statement it is taking us > 3mnts for this statement execution for a single record extraction.

How can we over come this in a report?

SELECT SINGLE WRTFW_KPF FROM CKIS

INTO V_TEMP

WHERE KALNR = T_KEKO-KALNR

AND KALKA = T_KEKO-KALKA

AND KADKY = T_KEKO-KADKY

AND TVERS = T_KEKO-TVERS

AND BWVAR = T_KEKO-BWVAR

AND KKZMA NE 'X'

AND KSTAR = '510060'.

regards

Praveen

Message was edited by:

PRAVEEN s

Re: Performance issue -Select single statement -CKIS table

Former Member — Wed, 31 Jan 2007 16:26:20 GMT

try passing even LEDNR & BZOBJ fields in the where condition...

if u can't then u need to create a index for all the fields used in where condition..

award points and close duplicate threads.

Re: Performance issue -Select single statement -CKIS table

Former Member — Wed, 31 Jan 2007 16:28:27 GMT

Hi Praveen,

try to select with the whole Key with LEDNR BZOBJ.

instead of KKZMA NE 'X' you can use KKZMA = space.

Hope it helps.

Regards, Dieter

Re: Performance issue -Select single statement -CKIS table

Former Member — Wed, 31 Jan 2007 16:30:35 GMT

HI Praveen,

I think its not the select single statement that is taking too much time, but keeping it inside a loop makes it take loger time.

Remove the select single from inside the loop and use for all entries instead.

Regards,

ravi

Re: Performance issue -Select single statement -CKIS table

Former Member — Wed, 31 Jan 2007 16:44:40 GMT

Hi All,

thank you for your advises.

I will let you know the results soon.

Regards

Praveen

Re: Performance issue -Select single statement -CKIS table

Former Member — Wed, 31 Jan 2007 16:50:48 GMT

Hi,

I resolved my issue by following the Index.

SELECT SINGLE WRTFW_KPF FROM CKIS

INTO V_TEMP

WHERE LEDNR = '00'

AND BZOBJ = '0'

AND KALNR = T_KEKO-KALNR

AND KALKA = T_KEKO-KALKA

AND KADKY = T_KEKO-KADKY

AND TVERS = T_KEKO-TVERS

AND BWVAR = T_KEKO-BWVAR

AND KKZMA EQ SPACE

AND KSTAR = '510060'.

Now it is super fast..

Thank you..

Praveen

Re: Performance issue -Select single statement -CKIS table

Former Member — Wed, 31 Jan 2007 17:01:00 GMT

Are you sure BZOBJ will always be '0'? It's '2' in our system.

Rob