02-02-2007 8:58 AM
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.
02-02-2007 9:01 AM
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
02-02-2007 9:02 AM
If you DELTE FROM DTAB ,u have to use where conditions,
use DELETE ZTABLE.
02-02-2007 9:04 AM
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.
02-02-2007 9:07 AM
Go to database utility and delete the table entires.
and regenerate the entries.
02-02-2007 9:09 AM
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.