SQL Performance (MOSC)

MOSC Banner

Tune a delete stament

edited May 2, 2015 10:00AM in SQL Performance (MOSC) 1 commentAnswered

Hi guys

i want to tune a delete with select condition statement

this is the condition

select *

from baan.tfxinh115377

where t$koor = 0 and t$ityp = 3 and t$attr = 98;

and they are around 16M rows (16581349)

Do you recommend this statement or there is some way to improve it?

delete from baan.tfxinh115377

where exists

(select * from baan.tfxinh115377

where t$koor = 0 and t$ityp = 3 and t$attr = 98);

Jesus

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