Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Indexed table, but database selection is still slow

Former Member
0 Kudos

hi guys,

i have made secondary for table zserial but the selection is still slow, did i miss any step ? do i need to reconstruct table ? if yes how can i do that to speed up my data selection

1 ACCEPTED SOLUTION

0 Kudos

Hi,

Have you added MANDT field when are creating the secondary index.

Regards,

Krishna

6 REPLIES 6

0 Kudos

Hi,

Have you added MANDT field when are creating the secondary index.

Regards,

Krishna

0 Kudos

Hi Khrisna,

I have added mandt but the program is still slow to seleect data

0 Kudos

Hi,

Check the performance trace using transaction code STAT

jayakummar
Active Participant
0 Kudos

hai,

can you give your code?

i will analys and get you what is the prob?

regards,

jai.m

0 Kudos

hi here is the code:

SELECT SINGLE * FROM zserial WHERE posid = i_prps2-posid

AND anln1 = i_cobrb-anln1.

Former Member
0 Kudos

no