topic Re: select single -performance issue -CKIS table in Application Development and Automation Discussions

select single -performance issue -CKIS table

Former Member — Wed, 31 Jan 2007 16:17:48 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

Re: select single -performance issue -CKIS table

Former Member — Wed, 31 Jan 2007 16:24:40 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.

Message was edited by:

Ramesh Babu Chirumamilla

Re: select single -performance issue -CKIS table

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

Hi,

u can aswell try removing the NE condition and delete the unwated records after the select statement.

regards,

madhumitha

Re: select single -performance issue -CKIS table

Former Member — Thu, 01 Feb 2007 04:37:12 GMT

Praveen,

IN CKIS table LEDNR is the main Key.Hence it is taking time check by avalble data is there any possiblity to get LEDNR before this Selection .If so pass that value to this select statement.....

Re: select single -performance issue -CKIS table

Former Member — Thu, 01 Feb 2007 06:15:22 GMT

Most of the fields in your selection are having multiple values try to use the POSNR or MATNR or KSTAR

this may improve the peroformance

Hope this helps

Thanks

Shiva

Re: select single -performance issue -CKIS table

Former Member — Thu, 01 Feb 2007 07:08:24 GMT

hi Pravenn..

in this table the is more number of fields as a primary key.. but u r selection query is passing not all the fields..in the primary key.. try to use most of the primary key values..

LEDNR
BZOBJ
KALNR
KALKA
KADKY
TVERS
BWVAR
KKZMA
POSNR