Skip to Content
0
Former Member
May 27, 2008 at 01:10 PM

Select Query performance issue

28 Views

Dear Gurus,

Pls see the following query....its taking a lot time & giving runtime error TSV_TNEW_PAGE_ALLOC_FAILED as no of records being fetched is around 1950000.

SELECT * FROM bseg

INTO CORRESPONDING FIELDS* OF TABLE it_final

for all entries in t_bkpf where belnr = t_bkpf-belnr

and gjahr in so_gjahr and bukrs = 'NDPL'.

Pls see & tell hw cn i modify this. Also i m unable to find indexes for table bseg.

Thnx.