Empy table

Isaac Yassin

Empy table
If you can't use "load dummy" to delete the rows from your table (somewhere
it was written that ann application program does it in "delete" command) and
you can't replace the logic of the whole process then
hope it's segmented and not simple or partitioned (delete from segmented
clears the space map, from the other it has to go thru the pages...)

Take it out of the program and if needed - change the logic of the whole
process, otherwise you'll pay dearly.

Isaac Yassin
DBMS & IT Consultant
[login to unmask email]