sqlplus vs pl/sql

[kris123]

Thanks dear,

But it is still doing full table scan

Im puzzled about the departure_date, why is it that when i remove it
the response is fast(in pl/sql mode), But while on the sqlplus mode
with or without the departure_date the performance is ok.