select single -performance issue -CKIS table

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

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

regards,

madhumitha

[Former Member]

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.....

[Former Member]

Hi

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

[Former Member]

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