deleting Table Entries

[Former Member]

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.

[Former Member]

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.

[Former Member]

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]

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

use DELETE ZTABLE.

[Former Member]

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]

Go to database utility and delete the table entires.

and regenerate the entries.

[Former Member]

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.