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: 

deleting Table Entries

Former Member
0 Kudos

Hi Group,

How to delete the table Z-table entries(the entries around 50Lakhs).When Im using

<b>Delete from Ztab</b>,it is taking lots of time is there any procedure other than this to increase the performanace.

5 REPLIES 5

Former Member
0 Kudos

YOU CAN TRY LIKE THIS

SELECT * FROM ZTAB INTO TABLE ITAB WHERE<.>.

DELETE ZTAB FROM TABLE ITAB.

IT MAY INCREASE THE PERFORMANCE.

REGARDS

SHIBA DUTTA

Former Member
0 Kudos

If you DELTE FROM DTAB ,u have to use where conditions,

use DELETE ZTABLE.

Former Member
0 Kudos

1) try for

DELETE FROM dbtab. or

DELETE FROM (dbtabname) . only.

2) other delete entries based on some combination of keys..like 1000000 entries in one shot.

Former Member
0 Kudos

Go to database utility and delete the table entires.

and regenerate the entries.

Former Member
0 Kudos

SWabap,

SELECT * FROM ZTAB INTO TABLE ITAB

PACKAGE SIZE 50000.

DELETE ZTAB FROM TABLE ITAB.

ENDSELECT.

This will increase program performance.

Pls. Mark if useful.