hi all,

i had a delete statement like this in a trigger

delete from histo where num <(b1 -30000)
b1 is a parameter coming from a sequence

there's an index on num and only on that colum which is the primary key

when i look at the plan he always do a full table scan to delete

why ? is it coming from the parameters