An Oracle blog – Amardeep Sidhu

October 8, 2009

Delete Delete Faster Faster ;)

Filed under: SQL — Sidhu @ 8:53 pm
Tags: ,

2-3 days ago, I came across a code, intended to make delete faster. Just have a look 😉

.
.
.
LOOP
SELECT COUNT (1)
INTO v_cnt
FROM table1
WHERE ROWNUM < 2;

IF v_cnt = 0
THEN
EXIT;
END IF;

DELETE FROM table1
WHERE ROWNUM < 1000;

COMMIT;
v_cnt := 0;
END LOOP;
.
.
.

Theme: Rubric. Get a free blog at WordPress.com

%d bloggers like this: