SQL Performance (MOSC)

MOSC Banner

how to do more efficient a delete stament

edited May 23, 2015 8:40AM in SQL Performance (MOSC) 12 commentsAnswered

Hi Guys

The delete statement i 'd like to try does a purge of more than 16M rows

select * from baan.tfxinh115377 where t$koor = 0 and t$ityp = 3 and t$attr = 98

COUNT(1)

----------

  16581349

Probably I 'll use

delete from baan.tfxinh115377 where t$koor = 0 and t$ityp = 3 and t$attr = 98;

but the issue it would be the undo right; I've doing a research on it could be and i guess one it could be this

set serveroutput on

declare

   VCOUNT number :=0;

    cursor c1 is select * from baan.tfxinh115377 where t$koor = 0 and t$ityp = 3 and t$attr = 98;

   begin

     for c1rec in c1 loop

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center